Maximum number of Sheets?

[Anthony Slater]

Just a quick question: -

How many sheets can a work book have?

The reason I am asking is that I have a very large
spreadsheet that contains a nested Vlookup formula to
return values from other workbooks. I am thinking of
transfering all the sheets from the other workbooks to my
main Spreadsheet to speed up the Vlookup process( which
can take a very long time).

They will be around 100 sheets. IS this possible

 

[Leo Heuser]

Anthony

Yes, that's possible. The number of sheets
only depends on the amount of memory in
your computer.

 

[Frank Kabel]

Hi
as Leo said: this is possible. For some more information see:
http://www.decisionmodels.com/memlimits.htm