| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum tabs in Excel?
Chip,
Many thanks for your reply - really useful. "Chip Pearson" wrote: It is worth noting that David's reply, that it is limited by memory, implies that it is limited by the memory on each computer on which the file will be used. If you have a high-end machine with loads of free memory, you may be able to add a great many sheets. But if you send the workbook to another user whose machine has less available memory, they won't be able to (1) see all the sheets, or, perhaps (2) open the workbook at all. My personal feeling is that a workbook is getting too large when you get up around 200 worksheets. There may be cases in which it makes sense (e.g., one sheet per day of the year), but often it just makes a workbook hard to work with. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 18 Dec 2008 12:55:13 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: If by "tabs" you mean "worksheets", the number in a workbook is limted by memory, rather than by any arbitrary limit in Excel. You say "it is erroring", but it may be better if you tell the group exactly what error message you are getting. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
| why excel sometimes goes to maximum row? | Excel Discussion (Misc queries) | |||
| Can i set up tabs within tabs on Excel? | Excel Worksheet Functions | |||
| what is maximum row length in excel | Excel Discussion (Misc queries) | |||
| Maximum no of rows in Excel | Excel Worksheet Functions | |||
Threaded Mode
