If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
manual calculation doc
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? |
#2
|
|||
|
|||
manual calculation doc
The #NAME? error is usually created because a Function is not available. This
could be a User Defined Function or an Excel Function. Check ToolsAdd-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 On Tue, 11 Nov 2003 08:02:55 -0800, "Sheri" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|