![]() |
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 |
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 |
All times are GMT +1. The time now is 08:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com