manual calculation doc

  • Thread starter Thread starter Sheri
  • Start date Start date
S

Sheri

A monthly excel report sent from our corporate office to
our remote location is saved by the sender in Manual
calculation. With no other excel documents open, opening
this document gives values of #NAME? where there should be
dollar values. Going to Tools/Options/Calculation tab and
choosing Manual and Calc Sheet does not make a
difference. Can anyone help me?
 
The #NAME? error is usually created because a Function is not available. This
could be a User Defined Function or an Excel Function.

Check Tools>Add-ins and put a check in Analysis Toolpak then hit CRTL + F9 to
re-calulate the sheet. This is the most common fix.

Gord Dibben XL2002
 
Back
Top