| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit on number of Sheets in a Workbook?
Is there a limit? One a macro I'm working on it will create 500 - 600 sheets in my workbook. Is this going to work in Excel or is there a limit on the number of sheets I can have?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Limit on number of Sheets in a Workbook?
Hi
depending on your Excel version only the memory limits the number of sheets (see the Excel help under 'Specification). Also have a look at http://www.decisionmodels.com/memlimits.htm -- Regards Frank Kabel Frankfurt, Germany Mr B wrote: Is there a limit? One a macro I'm working on it will create 500 - 600 sheets in my workbook. Is this going to work in Excel or is there a limit on the number of sheets I can have? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want to share workbook but limit the sheets each user sees | Excel Worksheet Functions | |||
| how do I limit the Number of rows in an excel 2007 workbook | Setting up and Configuration of Excel | |||
| max number of sheets possible in a workbook? | Excel Discussion (Misc queries) | |||
| How do I limit the number of times an Excel workbook can be opene. | Excel Discussion (Misc queries) | |||
| Limit on number of embedded controls in a workbook? | Excel Programming | |||
![Mr B[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
