CUMPRINC #NAME? error when file saved with new name

  • Thread starter Thread starter bertel
  • Start date Start date
B

bertel

When I save my spreadsheet under a new name to use on a new project,
get the #NAME? error on several financial functions.

- Analysis ToolPak add-in is installed.
- The erring functions reference figures from a different page/ta
of the same spreadsheet.
- The original spreadsheet functions properly.
- When I save under a new file name I get #NAME? errors.

The file is attached. The failure begins on line 22 of the 'Cash Flow
page.

Any suggestions are appreciated. Otherwise I have to replug number
with every scenario but am unable to save the scenario.

Thanks,
Brian
:confused

Attachment filename: park cash flow analysis.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45150
 
Hi Brian!

It's difficult to investigate this because your workbook uploads in a Read
Only format.

Send an unprotected copy direct and I'll investigate. Also, what version of
Excel are you using?

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top