Problem opening file created in Office97 using Office XP

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a file created Using excel from office 97 which is
used on a Win 98 Op system. I copied the file to an XP
machine with Office XP For students and teachers. The
file opens, but several formulas do not work instead give
a #name? or just ####### where there should be numbers.
Any suggestions
 
Hi Chris!

Use:
Tools > Addins
Place a check against Analysis ToolPak
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I just tried your suggestion and the file still has the
same errors. I unprotected the worksheet and overwrote
the formulas with the correct hard numbers, and the
errors went away. I would still like to know what caused
them in the first place.
 
Hi Chris!

The classic cause is when Analysis ToolPak isn't installed and
selected as an Addin. This can have rolling affects throughout the
workbook to dependent cells.

###### can indicate a column width is too narrow but it might be the
amount of text you have in a cell without word wrap. Or it could be
time calculations that result in negative times where the 1900 date
system is being used.

Generally the #NAME! error indicates a missing function or that you
have used a name that you haven't defined.

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