How many worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
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 |:>)
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sudden drop in Fibre Broadband Speed 8
Using Caledar Control 9.0 to select a worksheet 2
Clustering worksheets 1
Is there a maximum of the number of worksheets in a workbook? 6
how to populate many worksheets in a workbook 4
How many hours a week do you play computer games? 19
Unable to Insert Worksheets or Change Tab Names 4
Insert Worksheet? 2

Back
Top