Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum tabs in Excel?
I need to import a large amount of data (of unknown size) into Excel.
Each item of data needs to go on a new tab - and when attempting the import it is erroring. What is ther maximum number of tabs I can create in an Excel spreadsheet? many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum tabs in Excel?
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. -- David Biddulph "Zakynthos" wrote in message ... I need to import a large amount of data (of unknown size) into Excel. Each item of data needs to go on a new tab - and when attempting the import it is erroring. What is ther maximum number of tabs I can create in an Excel spreadsheet? many thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum tabs in Excel?
david,
Thanks for that - really helpful - I'll check again the kind of error message and report back. "David Biddulph" 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. -- David Biddulph "Zakynthos" wrote in message ... I need to import a large amount of data (of unknown size) into Excel. Each item of data needs to go on a new tab - and when attempting the import it is erroring. What is ther maximum number of tabs I can create in an Excel spreadsheet? many thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maximum tabs in Excel?
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. |
#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. |
Reply |
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 |