 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008#NAME? in Cells
Hi, We got a accounting spreadsheet via e-mail from a client which contains a lot of formulas. This file can be open by all the computers; however, one two computers, the cells show #NAME? instead of the numbers. All the computers have Office 2003 SP2 (we cannot install SP3 because of some third party software) and one has Office 2007 SP1 and the computer with office 2003 is one of the two computer that cannot see the numbers. It seems like an issue with the computers, not the file. Please help, thanks, Steve Louie > We got a accounting spreadsheet via e-mail from a client which contains > a lot of formulas. This file can be open by all the computers; however, > one [of the] two computers, the cells show #NAME? instead of the numbers. It would be helpful to know what function names are referenced in the cell. My guess: something in the Analysis ToolPak, a MS add-in. Even though the ATP is on the Excel installation disk, you must explicitly install it, both from the disk and into each workbook. For more information, see the Help page for EOMONTH (for example) and see the instructions for dealing with the #NAME error. Of course, the accounting workbook might also depend on 3rd-party add- ins. But it seems unlikely that you would have (coincidentally) installed them any computer, much less all but one. HTH.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.