Share via

Error Message - Reference is not valid

Anonymous
2011-03-09T21:06:02+00:00

When I select "Refresh All" [CTRL][ALT][F5] I get the error message "Reference is not valid."  I cannot determine how to locate the invalid reference.  Thanks is advance for your help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-03-09T23:06:47+00:00

    I don't have any linked files.  Is there any way to try to pinpoint the source of the problem?  I've tried doing error check on each tab of the workbook ... nothing.  I've deleted the tab with all of my pivot tables ... still get the error.

    Not sure what to do next ...

    Thanks.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-03-09T22:53:15+00:00

    Perhaps you have moved the file(S) to a different directory and the linking is looking back at the old location?

    hth

    Vaya con Dios,

    Chuck, CABGx3

    Was this answer helpful?

    0 comments