a formula in the worksheet contains one or more invalid references

Posted on 2009-12-30
Medium Priority
Last Modified: 2012-05-08
After converting to Excel 2007, I get the message above. I have already gone through the usual approach of trying to 'Find" {},[], etc. Can yo shed any light as to where else to look?
Question by:SteveEBS
  • 2
LVL 46

Expert Comment

ID: 26152482
Try clicking CTRL-G and select special, then search for formula errors.
also #REF!


Author Comment

ID: 26153454
Thanks, Gary. I have searched through all formulas and cannot find a reference error. I have found what may be the root of the problem though and that is an external reference that no longer exists. However, I cannot break this link using the "Break Link" option in the "Edit Links" utility. Any insight as to why a link cannot be broken?

LVL 46

Accepted Solution

tbsgadi earned 2000 total points
ID: 26153575
Try saving the file under the same name as the file it links to.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question