Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying workbook
When I copied the entire workbook to a new workbook using code, the
values in the corresponding cells were different due to rounding off errors. The new workbook has values which are more accurate. When I went to Tools - Options - Calculations and unchecked the "precision as displayed", the corresponding values in the 2 workbooks became the same. However, this did not solve my problem because wat I really wanted was "precision as displayed" on the screen and not to uncheck it. But if I leave it checked, the new workbook has values different from my current workbook. How do I solve this problem so that the new workbook has exactly the same values as my current workbook? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying workbook
Set the formatting at the same precision as in the source workbook. If you
want the same precision in both and both are controlled with precision as displayed, then display both workbooks at the same precision/formatting. -- Regards, Tom Ogilvy courtesio99 wrote in message ... When I copied the entire workbook to a new workbook using code, the values in the corresponding cells were different due to rounding off errors. The new workbook has values which are more accurate. When I went to Tools - Options - Calculations and unchecked the "precision as displayed", the corresponding values in the 2 workbooks became the same. However, this did not solve my problem because wat I really wanted was "precision as displayed" on the screen and not to uncheck it. But if I leave it checked, the new workbook has values different from my current workbook. How do I solve this problem so that the new workbook has exactly the same values as my current workbook? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying workbook formating to a differnent workbook | Excel Worksheet Functions | |||
copying modules from one workbook to another workbook | Excel Discussion (Misc queries) | |||
Copying Formulas from Workbook to Workbook | Excel Discussion (Misc queries) | |||
Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
Copying charts from workbook to workbook | Charts and Charting in Excel |