formula result not displayed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large spreadsheet (28MB) that is not displaying formulas results in
one worksheet. The formulas are not complex (ex., +'Placeholders 2006
Master'!$L$80*'Placeholders 2006 Master'!AO$141). If I go to any cell and
hit F2 to edit it directly that cell will display its result, even if it is
referencing another cell that is experiencing the same problem.

A simple F9 does nothing but I discovered by accident that Ctl ALt Shift F9
did cause the formulas to calculate. Does anyone know why this happens and
how we can keep it from happening again?

Thanks for any help
 
You might have automatic calculation turned off, try:

Tools->Options->'Calculation' Tab->Check 'Automatic'
 
Sorry I should have mentioned this in the original post. Automatic
calculation is turned on so that is not the problem
 
It sound as if the cells you are referring to are formatted as text. Try
entering 1 in an empty cell and copy it, select the entire range of the
offending cells an do 'Paste Special', check 'Multiply 'OK'. What this does
is to force a cell format back from text to number, or whatever.
To avoid the problem in the future (assuming this is the problem), make sure
the formulas you enter are not entered in cells formatted as text,
Regards,
Alan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Result = Volatile ?? 3
Recalculation does not work 8
Formula result not displaying correctly 2
Formula displays as formula, not as result 2
Formula in Excel does not work until after I double-click inside c 7
Formula not updating 1
hyperlink to cell based on formula results 4
Displaying results in formula bar when cell is hidden 1

Back
Top