+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : "reference is not valid" error message

  1. #1
    Registered User
    Join Date
    05-19-2009
    Location
    Hampshire, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    "reference is not valid" error message

    OK, mr mod, lets try again.

    Hi, I'm a newbie so excuse me if you are nice or flame me if you are not, but I need to use an excel book (written in 2003v ) on my vista machine running office 2007. I know little about the settings etc but having amended the macro's it has been working for months.

    Now it comes up with the "reference is not valid" error message and all I can do is wait for autosave and then crash out of it via task manager. This does not happen straight away but seems to be when I click on a free format notes section.

    I saw mention of this message elsewhere on this forum but there was talk of vsb etc that means little to me.

    If anyone can help I would appreciate it.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: "reference is not valid" error message

    Confused, our intention is not to flame or further confuse you, but help you and others when using the forum. You should have just edited your previous thread's title by clicking the 'Edit' button in the first post in the thread, rather than starting this new one. Just to make it simple I closed that thread, and you can continue using this one.

    As for your error, sometimes when users write vba (macro) code, they add references to one or more external files or objects that aren't there by default. Might I suggest uploading a copy of the workbook to this thread so we can see what the macro is trying to do, and then hopefully lead us to a resolution?

    Thanks,
    Paul

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1