Monday, July 4, 2016

Prevent Excel from Refreshing Data When Copying and Pasting


When copying dynamic data out of excel when pasting the value pasted changes.


Change the setting in excel to perform automatic calculations:

File tab -> options -> Formulas side tab -> Under the calculation Options, workbook calculation, select manual. Optionally you can shut off recalculate workbook before saving depending on situation.

Co-worker and tested with my own application.