1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

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

Discussion in 'Business Applications' started by LeanneGillick, Aug 8, 2001.

Thread Status:
Not open for further replies.
Advertisement
  1. LeanneGillick

    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
     
  2. RandyG

    RandyG

    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?

     
  3. LeanneGillick

    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
     
  4. RandyG

    RandyG

    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.
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/50255

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice