Chart Out-of-Memory

Topic

New Reply

I have a worksheet with three graphs on a single graph page. The problem started occurring last week that whenever I open the file, I get an out-of-memory error. At the same time the main chart goes blank with the X-axis reverting to a single point.

If I click OK and then re-select the source data range, everything returns to “normal”.

The problem is that even when I “repair” the problem and everything seeks OK, the next time I open the file, it happens again.

It happens on multiple computers. I’ve run ScanDisk and checked for viruses. I’ve even done the detect and repair from Excel. I’ve re-installed Excel. All for nought. I’m stumped on this one.

I hope I’m making this problem clear. If not, I’d be glad to send a file to anyone willing to tackle this problem.

Could anyone please point me in the right direction?

Reply | Quote

Replies

I had a similar problem some time ago. I’ve solved it by copying the contents (including graphs) of the ‘corrupted’ file (sheet per sheet) to sheets in a new workbook and resetting the data source for the data in the graphs. I you are lucky the problems you describe will remain ‘attached’ to your old workbook that you should delete at the end.

Hope this works.

Reply | Quote

Something else I’ve used successfully with some of these sortsd of problems- but it only applies to Excel 2000, not to 97- I don’t know which version is being used.

I’ve exported the spreadsheets to html (File, Save As Web Page), then imported back into Excel. All macros, charts, etc are retained intact, and it seems to leave the workbook much cleaner.

Another thing you might look at is to see if there’s any invisible charts hanging around.

I use this procedure to check all my charts:

Dim ws As Worksheet
Dim cht As ChartObject
Dim i As Integer

For Each ws In ActiveWorkbook.Worksheets
ws.Activate
For i = ActiveSheet.ChartObjects.Count to 1 step -1
Set cht = ActiveSheet.ChartObjects(i)
Debug.Print cht.Name; ” ” ws.name; cht.Left; cht.Width; cht.Height; cht.Top
cht.Activate
cht.CopyPicture
Next
Next

I put a brekpoint on the first “next” statement. I first look to see what chart has been selected; if I can see a selected chart, then it’s probably OK. If I can’t, I paste the clipboard (created from the cht.CopyPicture) into another application, to see if the chart is a real one. I can also check the chart’s top, left etc charecteristics from the debug to determine if the chart is a real one.

If I determine from this the chart is a phantom, I can delete it manually, or by using ‘if cht.name = “xxx” then cht.Delete’. (btw, the reason I count the charts backwards is to allow for such a delete).

Reply | Quote

Reply | Quote

Excel 2000- SR-1. I’m not getting an error.

Two things I noticed-

.It thinks there’s macros. If I remove “module1” there’s no macro message- even though “macro1” does not contain macros.
.There’s links to other sheets. I answer “N” when it asks me if I want to open the links- obviously because I don’t have the other docs. I don’t know if it’s those other links causing the memory problems.

Geoff

Reply | Quote

Hi,

Like Geoff I opened the document no problems

The link seems to be to the Analysis ToolPak which I have enstalled and hence got no prompt to update links.

Try formatting the graphs to use simpler graphics and see if that eleviates the problem (They look very well)- it may be worth a try.

Andrew C

Reply | Quote