View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rayo K
 
Posts: n/a
Default Recurring Excel Formula error - multiple users affected!

Yesterday I encountered a problem with Excel formulas. Several cells began to
display the formula instead of the result on one of my spreadsheets.

My formula was simple: =$f$1

Instead of displaying the value of F1, it actually displays "=$F$1"

Reviewing the posts from yesterday, I count 4 people posting with the EXACT
SAME PROBLEM.

The symptoms are the same. Cells display the formula instead of the result.
NONE of the proposed solutions help.

I know most of the settings for Excel so I checked the obvious: Are cells
set to calculate automatically: YES. In the view settings are formulas
checked for display: NO. Is there a formula error that causes the formula to
be displayed (extra =): NO

Several people proposed checking whether the format was set to text:

FORMATTING AS TEXT IS NOT SUPPOSED TO DISPLAY FORMULAS!! Formatting as text
should display the formula RESULTS AS TEXT!

Why are so many people suddenly having this problem? Was there a recent
update to Excel that could affect this? Is there a coding error that somehow
was triggered by the date?

Is there anyone who can get to the bottom of this?