Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

LeanneGillick

Thread Starter
Joined
Aug 8, 2001
Messages
9
I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?

Leanne
 
Joined
Jun 26, 2000
Messages
7,762
Welcome to TSG.


Can this file be opened fine in Excel 97? Any chance that it is corrupted?


What are some of the error messages you are getting?

 

LeanneGillick

Thread Starter
Joined
Aug 8, 2001
Messages
9
The user tries to open a spreadsheet that has links and macros to another spreadsheet. The problem is that when clicking on enable macros it attempts to open the sheet then brings up an Microsoft Visual Basic error message of -

An error occurred while loading 'Sheet 471111111111111111111111111' Do
you want to continue loading the project?

When clicking on Yes it then brings up the error message -

Excel.exe has generated errors and will be closed by Windows. You will need to restart the program.

An error log is being generated.

When looking at the error log it then supplies the following
information regarding the error -

Application exception occurred:
App: excel.exe (pid=448)
When: 4/13/2001 @ 16:27:23.925
Exception number: c0000005 (access violation)

Other than this I have no other information.

Thanks

Leanne
 
Joined
Jun 26, 2000
Messages
7,762
See if this might be the cause of it.


I think it means changing the VB script in the application.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top