Compatability Issues between 2007 and 2003

[TLAngelo]

I have created an Excel workbook in 2007 and saved it in compatibility. Some
of the users with 2003 can see everything just fine and some cannot. They
have downloaded the compatibility pack and it still won't work. When they
open the file, some of the fields that are supposed to calculate return
"#NAME?", yet when they send the file back to me it looks fine!

Any suggestions?

Thank you!

Tania

 

[Fred Smith]

Excel we're good at. Mindreading not so good.

What formula is returning #NAME?

Regards,
Fred.

 

[TLAngelo]

The formula works fine because it works when I have the spreadsheet on my
computer which has Office 2007, but it does not work when it is on a computer
with 2003. They have the compatibility pack and the same add-ins that I have.

The formula is
=IF(A33="NA",(0),(NETWORKDAYS(B33,M33,$T$4:$T$9)-1)/2.4+(N33-C33))

Tania

 

[Don Guillett]

I just tried the formula in 2007 and 2003 and it appeared to work just fine.
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

 

[TLAngelo]

Thanks Don! I'll try that and see if it works.

Tania

 

[TLAngelo]

That did the trick Don!! Thanks so much!

Tania

I just tried the formula in 2007 and 2003 and it appeared to work just fine.
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Glad to help