Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Increase Number of Worksheets
Hi
I need to increase the total number of worksheets beyond the 256 max. I have seen some code to do this in other threads but I dont know where to begin with actually entering it! Be v. grateful for a step-by-step advise on resetting the max, say to 300 or 350. Many thanks and regards |
#2
|
|||
|
|||
Hi
in later Excel versions the number of sheets is only restricted by your memory. though depending of the size of each individual sheet I'd guess 256 is a little bit too much. BTW: For what do you need so many sheets? -- Regards Frank Kabel Frankfurt, Germany Hoochi Coochi Man wrote: Hi I need to increase the total number of worksheets beyond the 256 max. I have seen some code to do this in other threads but I dont know where to begin with actually entering it! Be v. grateful for a step-by-step advise on resetting the max, say to 300 or 350. Many thanks and regards |
#3
|
|||
|
|||
You can add an unlimited (well, limited by your machine's memory) number
of worksheets, but only 255 at a time. You can't reset that max. If you have a workbook with 255 sheets, you can select 45 sheets and choose Insert/Worksheets to get to 300. In article , "Hoochi Coochi Man" wrote: I need to increase the total number of worksheets beyond the 256 max. I have seen some code to do this in other threads but I dont know where to begin with actually entering it! Be v. grateful for a step-by-step advise on resetting the max, say to 300 or 350. |
#4
|
|||
|
|||
Hi Frank
I ned so many because I have built a rather amssive model of the performance of different shops and I need it to be in one workbook as there are lots of summary calculations. I am on version Excell 2002 and it does seem to be limited. Cheers Keith "Frank Kabel" wrote: Hi in later Excel versions the number of sheets is only restricted by your memory. though depending of the size of each individual sheet I'd guess 256 is a little bit too much. BTW: For what do you need so many sheets? -- Regards Frank Kabel Frankfurt, Germany Hoochi Coochi Man wrote: Hi I need to increase the total number of worksheets beyond the 256 max. I have seen some code to do this in other threads but I dont know where to begin with actually entering it! Be v. grateful for a step-by-step advise on resetting the max, say to 300 or 350. Many thanks and regards |
#5
|
|||
|
|||
Excellent! That works. Many thanks
Keith "JE McGimpsey" wrote: You can add an unlimited (well, limited by your machine's memory) number of worksheets, but only 255 at a time. You can't reset that max. If you have a workbook with 255 sheets, you can select 45 sheets and choose Insert/Worksheets to get to 300. In article , "Hoochi Coochi Man" wrote: I need to increase the total number of worksheets beyond the 256 max. I have seen some code to do this in other threads but I dont know where to begin with actually entering it! Be v. grateful for a step-by-step advise on resetting the max, say to 300 or 350. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Charting information from a number of worksheets | Charts and Charting in Excel | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |