Copying workbook with rounding off error

  • Thread starter Thread starter courtesio99
  • Start date Start date
C

courtesio99

When I copied the entire workbook to a new workbook using code, th
values in the corresponding cells were different due to rounding of
errors. The new workbook has values which are more accurate.

When I went to Tools -> Options -> Calculations and unchecked th
"precision as displayed", the corresponding values in the 2 workbook
became the same.

However, this did not solve my problem because wat I really wanted wa
"precision as displayed" on the screen and not to uncheck it. But if
leave it checked, the new workbook has values different from my curren
workbook.

How do I solve this problem so that the new workbook has exactly th
same values as my current workbook
 
Possibly the best way to make a copy of a workbook is to use the workbook
SaveCopyAs method rather than copy ranges or worksheets.

If two cells have the same number entered and the same number format and
Precision as Display set on in their workbooks, I don't see how they can
have different values. But if you're seeing that perhaps you could provide
us the exact steps to replicate it.
 
Back
Top