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.
They have requested Excel 2003 to be installed as well as 2007 so that they can work in whicever one they need for a specific file. This seems to be a poor solution to me, and I am convinced there must be a better fix.
One solution I can think of is to get the engineer to save in 2003 format, vet the file for any formula errors, fix them, and then keep it in 2003 format from then on. The file and worksheets are very big though, and they will argue that they shouldn't have to do this (which I agree with).
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.
They have requested Excel 2003 to be installed as well as 2007 so that they can work in whicever one they need for a specific file. This seems to be a poor solution to me, and I am convinced there must be a better fix.
One solution I can think of is to get the engineer to save in 2003 format, vet the file for any formula errors, fix them, and then keep it in 2003 format from then on. The file and worksheets are very big though, and they will argue that they shouldn't have to do this (which I agree with).