Problem with formula alarm

%3CLINGO-SUB%20id%3D%22lingo-sub-1991679%22%20slang%3D%22en-US%22%3EProblem%20with%20formula%20alarm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1991679%22%20slang%3D%22en-US%22%3E%3CP%3EI%26nbsp%3B%20have%20a%20large%20data%20base%20spreadsheet%2C%20this%20alarm%20keeps%20dropping%20down.%3C%2FP%3E%3CP%3E%22Excel%20found%20a%20problem%20with%20one%20or%20more%20formula%20references%20in%20ths%20worksheet.%3C%2FP%3E%3CP%3ECheck%20that%20the%20cell%20refs.....%20are%20all%20correct.%22%3C%2FP%3E%3CP%3EIs%20there%20anyway%20Excel%20can%20highlight%20the%20affected%20problems%3F%20I%20cant%20find%20them%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EBrian%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1991679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1992319%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20formula%20alarm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1992319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F548135%22%20target%3D%22_blank%22%3E%40Curlsc1%3C%2FA%3E%26nbsp%3BThere%20can%20be%20many%20causes%20for%20this%20to%20happen.%20Google%20for%20the%20text%20of%20the%20error%20message%20and%20you%20will%20get%20many%20hits%2C%20all%20of%20which%20describe%20possible%20causes%20and%20solutions.%20Like%20this%20one%3A%3C%2FP%3E%3CP%3E%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_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.thespreadsheetguru.com%2Fblog%2Ffix-excel-found-a-problem-with-formula-references-in-this-worksheet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I  have a large data base spreadsheet, this alarm keeps dropping down.

"Excel found a problem with one or more formula references in ths worksheet.

Check that the cell refs..... are all correct."

Is there anyway Excel can highlight the affected problems? I cant find them

 

Cheers

Brian

1 Reply

@Curlsc1 There can be many causes for this to happen. Google for the text of the error message and you will get many hits, all of which describe possible causes and solutions. Like this one:

https://www.thespreadsheetguru.com/blog/fix-excel-found-a-problem-with-formula-references-in-this-wo...