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

 

[Norie]

Who says you need to transfer everything to Access in one go?

Keep what you've got, it seems to be working.

When you can see about moving it to Access, and if you decide to start slowly at first.

As for having to recreate all the data you have, you might not have to.

That would really depend on how you currently have things set up.

 

[Smitty]

As for having to recreate all the data you have, you might not have to.

That would really depend on how you currently have things set up.

If you post a representative shot of a member sheet, someone can give you an idea of what it would take to turn the data into a format that Access can use.

I would think that you'd be able to provide much more meaninful data with Access than you can with Excel, simply based on the volume of sheets that you have.