When copying dynamic data out of excel when pasting the value pasted changes.
Solution:
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.
Source:
Co-worker and tested with my own application.
