#NAME error

  • Thread starter Thread starter Ashley
  • Start date Start date
A

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
 
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?
Click to expand...

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
 
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
 
Hi Ashley,
It's a workbook that
reference another workbook which is on another machine.
Click to expand...

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
 
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
 
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.
Click to expand...

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
 
Hi Jan,
Thank you very much but that would be too much of
a trouble for you. Your previous replies are appreciated.
Ashley
 
Back
Top