Worksheet Limit?

  • Thread starter Thread starter Monte Sliger
  • Start date Start date
M

Monte Sliger

Is there a limit to the number of worksheets within a workbook? I have a
workbook with a template and another worksheet. When I try to create any
new worksheets by copying the template, after the 38th copy (40 total
worksheets) I get an error message saying that no more new fonts can be
applied in this workbook.

Any help will be appreciated.
Monte Sliger
 
Monte, form excel help,
Maximum number of sheets in a workbook Limited by available memory
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
Paul,

Thanks. That is why I was getting different results from the same operation
at home and at work. At work I only have 512MB memory, at home I have
1024MB.

Does this mean if I create the workbook at home with the required number of
sheets that I will not be able to open it at work?

Thanks for the reply.
Monte Sliger
 
hi i´m fernanda and their is a limit for worksheet but is not that small the
limit it is bigger.
 
Also,

The limit seems to be physical memory since I have played with differing
amounts of virtual memory and it always stops at the same place (i.e. 40
total worksheets for this particular workbook on this machine. I will try
it at home tonight to see if the number of copies I can make of the template
is different.

I guess I will have to create multiple workbooks for each customer instead
of one workbook for each like I was planning.

If anyone has another suggestion, please let me know.

Thanks,
Monte Sliger
 

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

Back
Top