Excel2000 WBook w macros won't even open in 97!

ScottNiag

Active Member
Joined
Sep 3, 2002
Messages
260
I have a workbook with macros created in Excel 2000. I cannot open it on another computer with Excel97 loaded. I don't think it has anything to do with the macros, however, as even when I disable the macros, it still won't open. I get the following message

This program has performed an illegal operation and will be shut down. Clicking on details, I get:

EXCEL caused an invalid page fault in
module EXCEL.EXE at 0187:3008af45.
Registers:
EAX=00000000 CS=0187 EIP=3008af45 EFLGS=00210246
EBX=00000000 SS=018f ESP=00629a88 EBP=0062a348
ECX=0000000c DS=018f ESI=0185bcf8 FS=4cc7
EDX=00000000 ES=018f EDI=0185bd36 GS=0ef6
Bytes at CS:EIP:
0f b7 40 02 8d 04 40 c1 e0 04 03 c1 3b c8 73 2f
Stack dump:
0185bd36 0185bcf8 00000000 30708769 00629dc6 00000004 00629ba2
00000004 00000001 00000004 00629ba2 00629dc6 00000004 00000000
00000000 3f800000



Any ideas?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
There are a few differences between 97 and its successors. Try saving the original programme using Save As and modifying the 'excel workbook' to the one that includes 97.

HTH :)
 
Upvote 0

Forum statistics

Threads
1,214,838
Messages
6,121,885
Members
449,057
Latest member
Moo4247

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top