A
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
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