Link to home
Start Free TrialLog in
Avatar of SteveEBS
SteveEBS

asked on

a formula in the worksheet contains one or more invalid references

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?
Avatar of tbsgadi
tbsgadi
Flag of Israel image

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

Gary
Avatar of SteveEBS
SteveEBS

ASKER

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?

SteveEBS
ASKER CERTIFIED SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial