Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How many worksheets
How many worksheets can you have in one workbook. Right now we're doing a
file for all weeks of the year and we've got 30 in it, but it won't allow us to insert any more. Any way around this? |
#2
|
|||
|
|||
Excel help files state that you can insert as many sheets as your RAM can
handle. Perhaps you can use named ranges instead of separating in sheets "CTN" wrote: How many worksheets can you have in one workbook. Right now we're doing a file for all weeks of the year and we've got 30 in it, but it won't allow us to insert any more. Any way around this? |
#3
|
|||
|
|||
The number of worksheets is limited by the available resources.
How big is your file (megabytes)? -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy "CTN" wrote in message ... How many worksheets can you have in one workbook. Right now we're doing a file for all weeks of the year and we've got 30 in it, but it won't allow us to insert any more. Any way around this? |
#4
|
|||
|
|||
Hi CTN-
Textbook answer is 255 sheets. If you cannot insert more than 30 it may very well be the result of insufficient RAM. Which version of Excel, Windows and what happens when you try to insert more? Regards |:) "CTN" wrote: How many worksheets can you have in one workbook. Right now we're doing a file for all weeks of the year and we've got 30 in it, but it won't allow us to insert any more. Any way around this? |
#5
|
|||
|
|||
255 is the number of sheets in a new workbook. You can add more after that
but the number is limited by available resources. -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy "CyberTaz" wrote in message ... Hi CTN- Textbook answer is 255 sheets. If you cannot insert more than 30 it may very well be the result of insufficient RAM. Which version of Excel, Windows and what happens when you try to insert more? Regards |:) "CTN" wrote: How many worksheets can you have in one workbook. Right now we're doing a file for all weeks of the year and we've got 30 in it, but it won't allow us to insert any more. Any way around this? |
#6
|
|||
|
|||
The only ime I've actually seen it in a real life file, it died while adding
the 2005th worksheet. So I guess the number is 2004. At least sometimes. Best wishes Harald "CTN" skrev i melding ... How many worksheets can you have in one workbook. Right now we're doing a file for all weeks of the year and we've got 30 in it, but it won't allow us to insert any more. Any way around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill Worksheets | Excel Discussion (Misc queries) | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |