Adding sheets to workbook

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

Guest

I have a single workbook file that is currently 417 sheets and cannot seem to
add more sheets. Is there a file size limit preventing the additions? I
place my pointer on the tab, right click, click creat a copy, move to the
copy location, click OK and nothing happens. Thanks!
 
According to Excel Help it states there isn't a specific sheet limit. It is
dependent on memory.
 
Thanks for offering an answer. But, this does not appear to be a memory
problem. We have tried this process on systems with huge memory capacity and
still have the problem. My work around is to begin a file for the fourth
quarter data.
 
For version 2002, memory limit on stack is 128M. Version 2003, limit is 1G.
Even if you have more memory available, that is all Excel will use.
 
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

Excel Move or Copy Stopped Working? 0
Merge Multiple workbook sheets into one workbook 0
copy sheets 4
How do I protect Excel Workbook Structure except adding new sheets 3
Save all sheets in a new workbook 7
Excel Providing user message when RED X clicked & properly closing application. 2
transferring total sheet from one workbook to another 3
SEQUENTIAL NUMBERING OF WORKBOOKS 1

Back
Top