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?
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
SteveEBS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
also #REF!
Gary