Compatability Issues between 2007 and 2003

T

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
 
F

Fred Smith

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

What formula is returning #NAME?

Regards,
Fred.
 
T

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
 
D

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

TLAngelo

That did the trick Don!! Thanks so much!

Tania

Don Guillett said:
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top