Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compatibility Problem Excel 2003 x 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? -- Danilo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compatibility Problem Excel 2003 x 2007
Hi gdanilo
Maybe this is your problem ?? http://www.rondebruin.nl/atp.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "gdanilo" wrote in message ... 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? -- Danilo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Color palette compatibility Excel 2007 vs. 2003 | Excel Discussion (Misc queries) | |||
Office 2007 / 2003 compatibility problem | Excel Discussion (Misc queries) |