Worksheet limits


S

Steven

I am trying to create a workbook. It has many worksheets. when I try to
create any more, i get the following error.

Excel cannot complete this task with available resources. choose less data
or close other apps.

Is there a limit to how many sheets you can use?

Thanks
Steven
 
Ad

Advertisements

S

Shane Devenshire

Hi,

Technically Microsoft says you are limited by available memory, but I find I
crash after about 7000 sheets even though I have 8 GB of RAM.

Sometimes you can get around the problem by saving the file, closing it, and
reopening it. And then continuing what you are doing.
 

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

Top