Copy and Pasting Formulas Issue in Excel 2010
I have an user that is having trouble copying and pasting formulas from one spreadsheet to the next, when the user tries to copy and paste into another spreadsheet recent data it is only copying the values not the formulas. Can someone help on this I am
using microsoft excel 2010.
April 1st, 2015 12:03pm
Does the user open two workbooks in two different instances of Excel, for example to be able to move the workbook windows independently of each other? If so, the instances see each other as external programs, so copying between them doesn't preserve Excel-specific
aspects such as formulas.
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2015 12:30pm
the user is opening two different workbooks on seprate screens and trying to copy and paste data from one spreadsheet to the next but it is only copying over the value not the formulas.
April 1st, 2015 2:09pm
Yes all in the same instance
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2015 2:11pm
If the user is opening two workbooks on different screens in Excel 2010, I strongly suspect that he or she opened two instances of Excel.
Excel 2013 is the first version that lets you open workbooks in completely separate windows with one instance of Excel.
April 1st, 2015 3:06pm