From: Evert on 08/15/2002
I have an Excel sheet that generates the error:EXCEL caused an invalid page fault in
module EXCEL.EXE at 0167:3039129e. at random times when entering a number (Full error message below). Sheet users have reported this error happening most when calculation is set to Manual (not when setting it, but when working in a manual calculation enviroment). The users use Excel 97 SR2 on both '95 and '98 machines. This sheet contains an elaborate iteration routine (circular references set to iteration), a combobox menu and no custom user fuctions (too slow), but a large set of button-activated Macro's. It's also filled with numerous boolean functions, but I can't find an error as reported in the MS support listing . I have a feeling that using 10 iteration routines may somehow fool Excell's cell change tracking system. I might be a simple matter of a lack of sufficient RAM as well, but I can't pin the error down FUll message: EXCEL caused an invalid page fault in
module EXCEL.EXE at 0167:3039129e.
Registers:
EAX=013d02e8 CS=0167 EIP=3039129e EFLGS=00010216
EBX=008d9f14 SS=016f ESP=0062e810 EBP=0062f084
ECX=00000000 DS=016f ESI=00000000 FS=408f
EDX=00000060 ES=016f EDI=00000009 GS=0000
Bytes at CS:EIP:
ff 70 1c e8 6e c9 ca ff 56 53 e8 ec 02 00 00 85
Stack dump:
0143c19c 008d9f14 00000000 00420008 0073002d 00720065 00650069 00620073 3081600d 0062f4e0 00000000 0062ed38 00000000 00010000 00ffffff 0062ead0
| |
Votes:
Rating: 0
Delete: 0
|
|
--- Replies to this Problem ---
From: Pablo on 01/20/2003
This just happened to me and I spent all day uninstalling and re-installing Office as well as the Service Release update packs to no avail...until I found one VERY simple and effective fix at:http://support.microsoft.com/?kbid=812136 It has something to do with a damaged toobar file called Excel.xlb. The explanation is in the above Microsoft Excel help page. So, if you are still having this problem or anyone who is reading this is having this problem, try the quick 6 steps in the above link for a resolution before spending your entire day trying to fix what may be a very simple (but aggravating) problem.
| |
Votes:
Rating: 0
Delete: 0
|
|
From: P. on 10/10/2002
: I have an Excel sheet that generates the error:: EXCEL caused an invalid page fault in: module EXCEL.EXE at 0167:3039129e.: at random times when entering a number (Full error message below). Sheet users have reported this error happening most when calculation is set to Manual (not when setting it, but when working in a manual calculation enviroment). The users use Excel 97 SR2 on both '95 and '98 machines.: This sheet contains an elaborate iteration routine (circular references set to iteration), a combobox menu and no custom user fuctions (too slow), but a large set of button-activated Macro's. It's also filled with numerous boolean functions, but I can't find an error as reported in the MS support listing .: I have a feeling that using 10 iteration routines may somehow fool Excell's cell change tracking system. I might be a simple matter of a lack of sufficient RAM as well, but I can't pin the error down: FUll message:: EXCEL caused an invalid page fault in: module EXCEL.EXE at 0167:3039129e.: Registers:: EAX=013d02e8 CS=0167 EIP=3039129e EFLGS=00010216: EBX=008d9f14 SS=016f ESP=0062e810 EBP=0062f084: ECX=00000000 DS=016f ESI=00000000 FS=408f: EDX=00000060 ES=016f EDI=00000009 GS=0000: Bytes at CS:EIP:: ff 70 1c e8 6e c9 ca ff 56 53 e8 ec 02 00 00 85 : Stack dump:: 0143c19c 008d9f14 00000000 00420008 0073002d 00720065 00650069 00620073 3081600d 0062f4e0 00000000 0062ed38 00000000 00010000 00ffffff 0062ead0
| |
Votes:
Rating: 0
Delete: 0
|
|
From: Computerpilot on 08/21/2002
Sounds like you are a pro at troubleshooting. I am sure you make your company very happy with your services!Good luck. I am sure you will find a solution soon. Computerpilot
| |
Votes:
Rating: 0
Delete: 0
|
|
From: Evert on 08/19/2002
Bacically the sheet is an overgrown Excel sheet and does a lot of calcuations. Using a few iterative routines and converging tricks, I wouldn't want to use Acess. Not only is the sheet is heavy on calculations, intermediate results are used in other sheets. Add to that I can't work with Access, thoguh it shouldn't be hard.THe sheet uses a table with coefficients to calculate a polynomial (Using the very handy Sumproduct function). An iterative routine finds an intersection with a 3rd order polynomial. Several root-finding methods are used in the sheet. The sheet also has a lot of hidden/unhidden columns depending on user settings. Anyway, I'll try the Mr Excel pages. I removed the double sheet/workbook name issue, and I will throw the workbook on the company net soon to see if that can help. The Macro's are all used and tested. The problem is the sheet suffers from spontaneous lockups. Enter a number in manual calcuation mode and it may result in an illegal page fault. It is my first attempt at VBA programming, but all routines are very short and simple, I hoep I haven't made an undocumented error.
| |
Votes:
Rating: 0
Delete: 0
|
|
From: Computerpilot on 08/16/2002
Microsoft has claimed that some improperly written VBA in Excel can create fatal exception errors. However, if all subroutines run successfully, then it would be unusual for the error message to occur. I would make sure that all your macros run successfully and clean out any VBA that you might have tested but never used. Simply put, take one more look.I think that your other suggestion is very likely. However, a new number to a template is NOT sequentially assigned to every user on the network. I mean to say that each computer issues a separate name to the worksheet, which may or may not be the same as another computer on the network opening the same template. If computer 1 opens the template (first time from boot), then it will assign the number 1 after the name. When computer 2 opens the template on the network from another location on first boot, it will ALSO assign the name with the suffix of the number 1. It sounds like you are trying to get each template to add to a master database file, in which case you would have a problem with this. Unfortunately, I don't have a solution to that. However, my friends at www.mrexcel.com are EXTREMELY knowledgeable regarding all versions of Excel. Just curious, why not ACCESS???? Seems like this job would be better done in Access. Computerpilot
| |
Votes:
Rating: 0
Delete: 0
|
|
From: Evert on 08/15/2002
I have found out after a full day of internet consulting that I have made the critical mistake of having both the workbook and a worksheet share the same name. However, as the workbook is opened as a template, the workbook name is # with # a number relating to the number of sheet currently open on the network, so teh workbook actually has a different name.Note: I do not know if the error is solved by changing the relevant sheet name. If you have any suggestions that may lead to a solution.. well, you know...
| |
Votes:
Rating: 0
Delete: 0
|
|
|
