Compatibility Problem Excel 2003 x 2007

G

gdanilo

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compatibility Problem between Excel 2003 and 2007 0
Difficulty with compatibility mode and Track Changes 2
Excel 2007 from Excel 2003 #N/A Problem 1
Excel 2007 --> 2003 Compatibility 2
Excel does not accept text format! 0
Excel 2003 & 2007 formula compatibility 0
Excel - Wich Function should I use? 1
Opening XLS (2003) workbooks in 2007 (XLSX) 1

Top