"Excel found a problem with one or more formula references" - Please tell me where!
One of my least favorite messages that Excel provides is:
"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.
If Excel finds a problem, please Excel, tell us where it is.
Jon Peltier
shared this idea
23 comments
-
CLAUDE VAN HORN
commented
To find errors on a sheet, just open the formulas tab and click "error checking"
-
Anonymous
commented
Can not import PDF to Excel
-
Anders Ebro (TheSmileyCoder)
commented
It seems clear to me, that the only focus for MS now is the cloud versions of excel. Several desktop related issues are not being adressed. VBE has received no love for 15 years, and they don't want to invest in that either, despite millions of users depending on it every day.
-
Anonymous
commented
Agreed. Amazes me how they manage to make the look and feel of Excel worse with each new release, change for the sake of it, yet don't fix problems that real users in the real world want fixing, problems they've known about for many many years.
-
Mitch
commented
GLOBAL F9 for the Masses
Well, if you're going to fix this, go all in and give us "Stack Trace", so we can follow the logic Excel uses to arrive at the problem or, in general, the solution.
-
Johnson
commented
"Hi! There's supposedly a problem, but I can't be bothered to tell you what it is. Instead I'm just going to beep at you and give you a pop-up to close - every time you do anything, from now until the end of time."
Gee, I can't imagine how anyone could find that annoying. XD
-
Adaxis
commented
Please
-
Ingeborg Hawighorst
commented
Yes! If Excel can determine that there is a problem, it shouldn't be that hard to tell us where.
-
Enerkey Roger
commented
I am using windows 10. I also works on excel for my job.somedays ago I faced with this error the I saw this sitehttps://msofficetechnicalsupportnumbers.com/blog/how-to-fix-ms-excel-has-stopped-working-error/
and get a solution. You have to check something such as isolate the specific spreadsheet tab, check external links, check the name manager, check your charts, check your pivot tables. After you can solve the problem -
Anonymous
commented
Anonymous, You have used my account for a very long time I am so shocked
-
tim
commented
agree. need to know what range or object. must include named ranges, and conditional formats as well.
ps, Excel users have found a problem with Excel - please fix it
-
Ewald
commented
-
Ewald
commented
I think it's the following similar thread:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8778088-make-it-easier-to-find-external-links -
jim
commented
a bit like the point of this thread; you've identified a similar thread but failed to tell us where - I like the irony
-
Anonymous
commented
This is similar to an existing thread (currently 267 votes).
-
jim
commented
and links!
when I'm told my document has links to other files, please tell me where and what (cell formulae, charts, named ranges, pivot sources,... ...any others?)jim
-
Ewald
commented
see Ben Shneiderman's Eight Golden Rules of Interface Design.
(http://www.cs.umd.edu/~ben/goldenrules.html)
5. Prevent errors.
As much as possible, design the interface so that users cannot make serious errors; for example, gray out menu items that are not appropriate and do not allow alphabetic characters in numeric entry fields (Section 3.3.5). If users make an error, the interface should offer simple, constructive, and specific instructions for recovery. For example, users should not have to retype an entire name-address form if they enter an invalid zip code but rather should be guided to repair only the faulty part. Erroneous actions should leave the interface state unchanged, or the interface should give instructions about restoring the state. -
Ian Huitson
commented
Yes Please
-
Jan Karel Pieterse
commented
Yes please! Same goes for the message you get where Excel tells you it has removed something from a repaired workbook. But not what.
-
Jon Acampora
commented
Agreed! Please give us more info. Thanks! 🙂