Help with an error message

%3CLINGO-SUB%20id%3D%22lingo-sub-1581398%22%20slang%3D%22en-US%22%3EHelp%20with%20an%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581398%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20attached%20message%20pops%20up%20on%20every%20spreadsheet%20I%20open%20and%20it's%20driving%20me%20nuts.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20deleted%20Excel%20and%20reloaded%2C%20and%20still%20get%20the%20same%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20GREATLY%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1581398%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581540%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581540%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755980%22%20target%3D%22_blank%22%3E%40jeffharrellyo%3C%2FA%3E%26nbsp%3BI%20have%20suggestions%20for%20you%20as%20below%20to%20fix%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20First%20Go%20To%20Formulas%20%26gt%3BThen%20Name%20Manager%3C%2FP%3E%3CP%3E*%20Once%20you%20see%20the%20window%20here%20you%20will%20see%20all%20references%20listed%20as%20formula%20error%2C%20just%20Delete%20those%3C%2FP%3E%3CP%3E*%20Still%20you%20get%20the%20error%2C%20press%20Control%20%2B%20F%20key%20and%20find%20%22%23%22.%20It%20will%20how%20you%20all%20the%20cells%20where%20Formula%20errors%20are%20there.%20So%20you%20need%20to%20go%20and%20fix%20those.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20will%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EKapil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581615%22%20slang%3D%22de-DE%22%3ESubject%3A%20Help%20with%20an%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581615%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755980%22%20target%3D%22_blank%22%3E%40jeffharrellyo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ETry%20it%20with%20Conditional%20Formatting%20-%26gt%3B%20Delete%20Rules%20-%26gt%3B%20Delete%20Rules%20in%20Entire%20Sheet.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3ERef%20errors%20are%20mostly%20hidden%20in%20the%20conditional%20formatting%2C%20which%20can%20be%20eliminated.%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ENikolino%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EI%20know%20I%20don't%20know%20nothing%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Beware%20of%20scammers%20posting%20fake%20support%20numbers%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581805%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581805%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F476378%22%20target%3D%22_blank%22%3E%40jukapil%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20try%20but%20unfortunately%20still%20%26nbsp%3Bhas%20the%20error%20message.%20%26nbsp%3BThis%20one%20is%20frustrating.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581807%22%20slang%3D%22en-US%22%3EBetreff%3A%20Help%20with%20an%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581807%22%20slang%3D%22en-US%22%3EI%20thought%20this%20was%20going%20to%20work%20but%20still%20getting%20the%20same%20error%20message.%20Ugh!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581921%22%20slang%3D%22de-DE%22%3ESubject%3A%20Help%20with%20an%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581921%22%20slang%3D%22de-DE%22%3EUnfortunately%20I%20cannot%20help%20you%20any%20further.%20A%20Mac%20Excel%20specialist%20is%20required.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20nothing%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581995%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581995%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755980%22%20target%3D%22_blank%22%3E%40jeffharrellyo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20not%20sure%20if%20FindLink%20works%20on%20Mac%20or%20not%20(if%20works%20better%20to%20use%20it)%2C%20as%20variant%20here%20is%20step%20by%20step%20what%20to%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.thespreadsheetguru.com%2Fblog%2Ffix-excel-found-a-problem-with-formula-references-in-this-worksheet%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.thespreadsheetguru.com%2Fblog%2Ffix-excel-found-a-problem-with-formula-references-in-this-worksheet%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

@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

Highlighted

@jeffharrellyo 

 

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.

Highlighted

@jukapil 

 

Thanks for the try but unfortunately still  has the error message.  This one is frustrating.

Highlighted
I thought this was going to work but still getting the same error message. Ugh!
Highlighted
Unfortunately I cannot help you any further. A Mac Excel specialist is required.

Nikolino
I know I don't know nothing (Socrates)
Highlighted

@jeffharrellyo 

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-wo...

Highlighted

@Sergei Baklan Thanks for the info.  Will work through these options.  Thank you!