Desktop

Ask something
Discussion Locked

Invalid page fault

0 helpful
8 replies

by nhughes79

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When one of my users tried to access the source data, from a graph in Excel, they get an 'Not enough memeory' error message. When you OK this message, the illegal operation box comes up. When I click on the details tab, the following comes up....
'Excel caused an invalid page fault in module excel.exe at 0137 : 30126e9e

This problem is starting to get the better of me, so any help would be appreciated

Ragards

Neil Hughes

8 replies

by syscokid

Here's a possibility:
http://support.microsoft.com/support/kb/articles/Q172/9/48.ASP

XL97: "Not Enough Memory" Opening a Workbook with a Chart
---------------------------------------------

SYMPTOMS
When you open a workbook in Microsoft Excel 97, the following problems may occur:

You receive the following error message:
Not enough memory.
-and -

In the active chart, text is missing from both the legend and the chart title. Also, some or all of the chart series labels contain the text "0."

CAUSE
These problems occur if all of the following conditions are true:

When you open the workbook, a chart sheet is the active sheet.

-and-

The active chart sheet refers to cells in a worksheet that contain formulas that refer to one or more user-defined functions.

-and-

One of the user-defined functions uses the Volatile method by using the following line of code in the function:

Application.Volatile

WORKAROUND
To work around these problems, use either of the following methods:

Before you save the workbook, click a worksheet or chart sheet that does not refer to user-defined functions. When you do this, you ensure that the active sheet does not refer to a user-defined function.

-or-Remove Application.Volatile from any user-defined functions that are referenced by the chart sheet.

If you cannot change the active sheet or modify the user-defined functions, you can temporarily correct the chart by following these steps:
Switch to the worksheet that is referenced by the chart sheet.

Press CTRL+ALT+F9.

This forces the entire worksheet to be recalculated. When you switch to the chart sheet, the title, legend, and series labels appear correctly. Note that when you close and reopen the workbook, the problems may occur again.

by syscokid

Here's another, too long to be posted in full here.

From http://support.microsoft.com/support/kb/articles/Q168/6/50.ASP

SYMPTOMS
When you attempt to add a new chart to a workbook or access the chart data source, you may receive the following error message:

Not enough memory.

(Sometimes when I cut and paste URL's it looks ok to me but once the answer is posted, an extraneous space will have crept in. Make sure you delete any extraneous spaces or the page won't load).

by redshift

The original document could be corrupted. Open it at another PC and save it under another name, then try again.

Otherwise, answer 1 seems to be the end of it!

by snoshuu

One possible easy fix....
Open a blank workbook and copy contents of problem file to it.

1. Open problem Excel file.
2. Click File | New, select Workbook
3. Click Window and select the problem Excel file
4. Click Edit | Select All
5. Click Edit | Copy
6. Click Window and select the blank worksheet.
7. Click Edit | Paste Special and click OK.
8. Save the new workbook.

This discussion is closed to new replies.