Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Chart Out-of-Memory

    [img]/w3timages/icons/dizzy.gif[/img]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?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart Out-of-Memory

    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.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart Out-of-Memory

    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:

    [pre]
    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

    [pre]

    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).
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Chart Out-of-Memory

    [img]/w3timages/icons/dizzy.gif[/img]
    Attached Files Attached Files

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart Out-of-Memory

    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
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Chart Out-of-Memory

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •