|
Compatability Issues between 2007 and 2003
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 |
Compatability Issues between 2007 and 2003
Excel we're good at. Mindreading not so good.
What formula is returning #NAME? Regards, Fred. "TLAngelo" wrote in message ... 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 |
Compatability Issues between 2007 and 2003
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 "Fred Smith" wrote: Excel we're good at. Mindreading not so good. What formula is returning #NAME? Regards, Fred. "TLAngelo" wrote in message ... 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 |
Compatability Issues between 2007 and 2003
Thanks Don! I'll try that and see if it works.
Tania "Don Guillett" wrote: 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 "TLAngelo" wrote in message ... 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 "Fred Smith" wrote: Excel we're good at. Mindreading not so good. What formula is returning #NAME? Regards, Fred. "TLAngelo" wrote in message ... 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 |
Compatability Issues between 2007 and 2003
That did the trick Don!! Thanks so much!
Tania "Don Guillett" wrote: 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 "TLAngelo" wrote in message ... 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 "Fred Smith" wrote: Excel we're good at. Mindreading not so good. What formula is returning #NAME? Regards, Fred. "TLAngelo" wrote in message ... 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 |
Compatability Issues between 2007 and 2003
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "TLAngelo" wrote in message ... That did the trick Don!! Thanks so much! Tania "Don Guillett" wrote: 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 "TLAngelo" wrote in message ... 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 "Fred Smith" wrote: Excel we're good at. Mindreading not so good. What formula is returning #NAME? Regards, Fred. "TLAngelo" wrote in message ... 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 |
| All times are GMT +1. The time now is 02:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com