Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compatibility Problem between Excel 2003 and 2007
Excel 2007 imcorporated some functions which used to be in a add in previous
versions. This is the case, for example, for the workday() and networkdays() functions but there are some others. When I open a 2003 spreadsheet with this functions Excel prompts I'm using "reserved" names for user defined function which is now internal. The problem is when I save this 2003 spreadsheet in Excel 2007 (in a .xls format) and try to use it in Excel 2003 again, because something happens and I completely loose this formulas (sometimes I start have the #VALUE! error or even worse problems). Does anyone had similar problems and now how to solve it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compatibility Problem between Excel 2003 and 2007
Hi,
I can't duplicate this problem. First thing to do is make sure you have service pack 1 installed. -- If this helps, please click the Yes button Cheers, Shane Devenshire "gdanilo" wrote: Excel 2007 imcorporated some functions which used to be in a add in previous versions. This is the case, for example, for the workday() and networkdays() functions but there are some others. When I open a 2003 spreadsheet with this functions Excel prompts I'm using "reserved" names for user defined function which is now internal. The problem is when I save this 2003 spreadsheet in Excel 2007 (in a .xls format) and try to use it in Excel 2003 again, because something happens and I completely loose this formulas (sometimes I start have the #VALUE! error or even worse problems). Does anyone had similar problems and now how to solve it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compatibility Problem between Excel 2003 and 2007
Hi,
In addition you may want to look at http://support.microsoft.com/kb/951699 -- If this helps, please click the Yes button Cheers, Shane Devenshire "gdanilo" wrote: Excel 2007 imcorporated some functions which used to be in a add in previous versions. This is the case, for example, for the workday() and networkdays() functions but there are some others. When I open a 2003 spreadsheet with this functions Excel prompts I'm using "reserved" names for user defined function which is now internal. The problem is when I save this 2003 spreadsheet in Excel 2007 (in a .xls format) and try to use it in Excel 2003 again, because something happens and I completely loose this formulas (sometimes I start have the #VALUE! error or even worse problems). Does anyone had similar problems and now how to solve it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compatibility Problem Excel 2003 x 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 and Office 2007 Compatibility | Excel Discussion (Misc queries) | |||
Excel 2007/2003 Pivottable compatibility | Excel Discussion (Misc queries) | |||
Excel 2007/2003 compatibility problem - copy and paste | Excel Discussion (Misc queries) | |||
Office 2007 / 2003 compatibility problem | Excel Discussion (Misc queries) |