#NAME error

[Ashley]

Hi,
I open the same workbook on Office 2000 and Office XP.
Using Excel 2000 turn out to be fine but when I use Excel
XP some of the cells has the #NAME value error.
Can anyone please kindly assist?
Thank you.

Ashley

 

[Jan Karel Pieterse]

Hi Ashley,

I open the same workbook on Office 2000 and Office XP.
Using Excel 2000 turn out to be fine but when I use Excel
XP some of the cells has the #NAME value error.
Can anyone please kindly assist?

Very probably the Analysis Toolpak addin is not installed on the
offending computer. Select Tools, addins from the menu. Check "Analysis
Toolpak". If it doesn't show there, you need to run Office Setup and
make sure it is installed.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Ashley]

Hi Jan,
Thank you very much for your reply I have
installed the Analysis ToolPak Add-Ins and Analysis
ToolPak Add-Ins VBA. It still didn't help. I realised in
Excel 2000, Analysis ToolPak Add-Ins is not installed and
the values can be displayed out. It's a workbook that
reference another workbook which is on another machine.

Ashley

 

[Jan Karel Pieterse]

Hi Ashley,

It's a workbook that
reference another workbook which is on another machine.

Looks like that other workbook cannot be found. Does it contain User
defined functions by any chance?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Guest]

Hi Jan,
I think there is but it's weird in a way that Excel
2000 can view without errors but Excel XP has the #NAME
error.
Ashley

 

[Jan Karel Pieterse]

I think there is but it's weird in a way that Excel

2000 can view without errors but Excel XP has the #NAME
error.

You can send me the workbook by email if you like. I'll have a look at
it.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Ashley]

Hi Jan,
Thank you very much but that would be too much of
a trouble for you. Your previous replies are appreciated.
Ashley