ExcelBanter - # of Worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - # of Worksheets (https://www.excelbanter.com/excel-worksheet-functions/53164-worksheets.html)

Jeanne

# of Worksheets

How many worksheets can be used in one Excel file?

Anne Troy

# of Worksheets

This is limited by the resources available on the machine on which the file
is run. However (and I'm sure you'll get different opinions), I would not
personally use more than 30 or 40; perhaps 100 in extenuating circumstances.
Likely, if you explain what you're trying to accomplish, we can provide
better methods.
************
Anne Troy
www.OfficeArticles.com

"Jeanne" wrote in message
...
How many worksheets can be used in one Excel file?

All times are GMT +1. The time now is 01:15 PM.