No more hiding in the server room
Major issue with Excel 2003 vs 2007
Can you point me in the right direction to try and resolve the following issue please?
Our engineers use an Excel file to track project progress and we need to submit this weekly to the client for review.
One of the issues we found was that the subtotals from one version to the next would differ in value and one of the reasons we found was with the ISERROR difference between 2007 & 2003, but we did not go in depth to identify all the issues between the two versions of excel.
Imagine having to doubt the calculation every week when you submit the file to the client.
The problem does not occur when opening the file in Excel 2007 but when trying to save when already in 2007 to a 2003 version.
Our engineers use an Excel file to track project progress and we need to submit this weekly to the client for review.
One of the issues we found was that the subtotals from one version to the next would differ in value and one of the reasons we found was with the ISERROR difference between 2007 & 2003, but we did not go in depth to identify all the issues between the two versions of excel.
Imagine having to doubt the calculation every week when you submit the file to the client.
The problem does not occur when opening the file in Excel 2007 but when trying to save when already in 2007 to a 2003 version.
Views: 10
Replies to This Discussion
-
Permalink Reply by Paul Stoklosa on -
Have you tried it with 2007 sp2? 600 fixes and improvements! otherwise i'd recommend opening a case with microsoft support.. sounds like a problem that should be addressed in an update or the next sp...
-
Permalink Reply by Wayne Neilson on -
Hi Paul,
Thanks for your feedback.
The consensus from feedback seemed to be that the order of creation of the spreadsheet caused the problem.
We have asked them to open a new file in Excel 2007, immediately save as 97-2003 version, and then start building the worksheet, so that everything is done in Compatibility Mode.
This seems to have done the trick.
As a side - we are starting to look at rolling out SP2 to all Office 2007 users.
Cheers again,
Wayne
© 2012 Created by Elizabeth Ayer and Michael Francis.
Powered by
