Excel 2000 Limitations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 27 Sep 2004 20:22 GMT

We are bumping into Excel limits on a large spreadsheet
The file is about 25mb at the moment and growing quickly.

Here are some questions:
1. What are the finite limits of Excel 2000 with respect
to spreadsheets?
This implies anything - row, column, sheet, or cell
quantity and memory max size, macro limit, graphic
limits, memory limits, etc.

2. How can we predict these finite limits when they occur?

3. What can be done to resolve these finite limits when
they occur?

4. Is there a tool we could use to analyze an Excel
spreadsheet to "see" what is going on inside the program?

Reply to this Message

Nick Hodge - 28 Sep 2004 00:39 GMT

Paul

About the best answers you'll get to Excel memory allocation are at

http://www.decisionmodels.com/memlimits.htm

I run a spreadsheet every week from an Access database into a pivot table
and it is around 60mb so size depends very much on what you're doing. Works
flawlessly although I do cross my fingers when I save each week.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> We are bumping into Excel limits on a large spreadsheet
> The file is about 25mb at the moment and growing quickly.
[quoted text clipped - 13 lines]
> 4. Is there a tool we could use to analyze an Excel
> spreadsheet to "see" what is going on inside the program?

Reply to this Message