Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 and Office 2007 Compatibility Bob Excel Discussion (Misc queries) 1 December 5th 08 04:58 AM
Excel 2007/2003 Pivottable compatibility Michael Anderson Excel Discussion (Misc queries) 0 February 21st 08 02:55 AM
Excel 2007/2003 compatibility problem - copy and paste [email protected] Excel Discussion (Misc queries) 0 December 6th 07 02:57 PM
Color palette compatibility Excel 2007 vs. 2003 Grandor Excel Discussion (Misc queries) 0 May 1st 07 06:10 AM
Office 2007 / 2003 compatibility problem Joe Excel Discussion (Misc queries) 4 February 2nd 07 05:32 PM


All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"