Forum Discussion
Help with an error message
The attached message pops up on every spreadsheet I open and it's driving me nuts.
I've deleted Excel and reloaded, and still get the same error.
Any help would be GREATLY appreciated!
7 Replies
- SergeiBaklanDiamond Contributor
I'm not sure if FindLink works on Mac or not (if works better to use it), as variant here is step by step what to check https://www.thespreadsheetguru.com/blog/fix-excel-found-a-problem-with-formula-references-in-this-worksheet
- jeffharrellyoCopper Contributor
SergeiBaklan Thanks for the info. Will work through these options. Thank you!
- NikolinoDEPlatinum ContributorUnfortunately I cannot help you any further. A Mac Excel specialist is required.
Nikolino
I know I don't know nothing (Socrates) - NikolinoDEPlatinum Contributor
Try it with Conditional Formatting -> Delete Rules -> Delete Rules in Entire Sheet.
Ref errors are mostly hidden in the conditional formatting, which can be eliminated.I would be happy to know if I could help.
Nikolino
I know I don't know nothing (Socrates)* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
- jeffharrellyoCopper ContributorI thought this was going to work but still getting the same error message. Ugh!
jeffharrellyo I have suggestions for you as below to fix this:
* First Go To Formulas >Then Name Manager
* Once you see the window here you will see all references listed as formula error, just Delete those
* Still you get the error, press Control + F key and find "#". It will how you all the cells where Formula errors are there. So you need to go and fix those.
Hope this will help
Thanks
Kapil
- jeffharrellyoCopper Contributor