maximum sheets excel 2010 64bit

[spilner]

hi,what is the maximum sheets can excel 64bit create?
ive more than 10 thousands sheets currently at 60Mb.
it also take up 600-700MB of memory while idling and more than 1Gb of memory while run a macro.took up 1-2 mins to open tho.
i wish excel can make unlmited sheets.thanks

 

[VoG]

Limited by available memory http://office.microsoft.com/en-us/e...d-limits-HP010342495.aspx#BMworksheetworkbook

 

[spilner]

Kewl...thanks VoG.. ive 16gb of ram right now with intel i5 3.2GHz.
plan to upgrade to intel extreme i7 and intel extreme motherboard to make the excel run super much faster..

 

[Norie]

Just out of curiousity, why/how so many sheets?

 

[spilner]

A sheet is refer to a member.so there are 10 thousands members. i work for a multi level company and use excel to count.i know i should use ACCESS instead but i dont have knowledge..
Excel perform fast to me,i like it.when i run a macro,it just take about 3-4 minutes to count all the sheets.

 

[Norie]

You really should move this out of Excel, the only reason you are getting speeds like that is because of the hardware.

It would probably take seconds in a database like Access, even on a machine with half the power.

 

[spilner]

does Access still using same formulas like Excel?
will Access can run my currently macro?
if so,i will buy Access..
i just afraid i cant make it like what i want..

 

[Norie]

1 No, you wouldn't need formulas to count.

2 No, you wouldn't need code to count.

 

[Norie]

Oh, and buying Access might be a little cheaper than upgrading to an i7 Extreme.

 

[spilner]

if i want to move to access,ive a week only to learn and recreate all the 10 thousands sheets..if it take much longer...then my boss will pissed up and he can fired me :/
is it hard to learn Access? my knowledge on Excel just basic only.