Problem opening file created in Office97 using Office XP

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
 
N

Norman Harker

Hi Chris!

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

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

Guest

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.
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top