manual calculation doc

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?
 
G

Gord Dibben

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
 

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

Converting excel to PDF, single page converts to multiple HELP! 1
Excel not calculating formulas 3
Calculating what staff worked on which product 3
*****PLEASE******* FIX AUTOMATIC CALCULATION 1
VBA - exporting serial letters to single documents 0
Enable Iterative Calculations 0
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
Excel 2003 automatic calculation all worksheets except one 3

Top