ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Compatibility Problem Excel 2003 x 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/214925-compatibility-problem-excel-2003-x-2007-a.html)

gdanilo

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

Ron de Bruin

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