| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Compatability Pack for Office 2003 | Excel Discussion (Misc queries) | |||
| Compatibility issues with MS 2003 & 2007? | Excel Discussion (Misc queries) | |||
| Office 2003 and 2007 compatability install | Excel Discussion (Misc queries) | |||
| Excel compatability 2003-2007 | Setting up and Configuration of Excel | |||
| Compatability Issues Please help and comment | Excel Discussion (Misc queries) | |||
Linear Mode
