Not enoguh memory. Continue with Undo?

P

pierre_py

Hi.

Before i continue: DisplayAlerts is set to off (disabled).

We are running a code from python through com-automation on very huge
excel workbooks.
Now we want to comment all non-empty cells with custom comments.

After a number of cells, excel throws this message box saying "Not
enogh memory. Continue without undo?". If pressing OK ... the
messagebox comes back forever (can only shoot the excel instance
through taskmanager).

How can we programatically disable undo? Or where is the problem?

We are using o2k-sr1 (eng and german).

On smaller workbooks it works ok ... and actually the generated excel
(to the point of the mssagebox) is also OK (as it should be with all
the comments).

Please help and thanks in advance
 
P

pierre_py

Another thing to mention:

Sometimes i got another error saying: "Not enough system ressources to
display completely".
Although i can open the large workbook.
 
D

Dave Peterson

You can change the level of undo's in Excel:

xl2k and above
XL: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=211922

xl97
XL97: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=162944

=====
But I think I would think twice about using that many comments. My gut feeling
(only anecdotal evidence) is that a large number of comments on a worksheet can
corrupt that worksheet.

I had one worksheet that was corrupted. The only significant difference between
that sheet and a very similar sheet was the number of comments. I've been
reticent to use lots and lots of comments ever since. (This happened in xl97,
though.)
 
D

Dave Peterson

Do you have the zoom level set to 100%?

Maybe it's time to test on a more powerful pc???
 
Top