Excel copy and paste formulas

All,

We have a group of users in our Finance department who have opened an incident with our Service Desk stating that once upgraded to Windows 7 and Office 2010 Professional, they have lost the ability to open two instances of Excel and copy and paste formulas between the instances.  Everything I have found online states that this should not have been possible to begin with.  Is there a way that they can open two worksheets in seperate windows and copy and paste the formulas between open sheets?  They have dual monitor setups and would like one sheet open on each monitor to perform their work.

Any assistance would be greatly appreciated.

Eric

June 11th, 2012 8:37pm

Hi,

I think we can open both workbooks in the same instance of Excel. Then maximize Excel across both screens and tile the file windows so you see both workbooks. You can then copy and paste with all Paste Special options available.

Free Windows Admin Tool Kit Click here and download it now
June 12th, 2012 9:20am

I am having the same issue my user is not able to copy and paste formulas in the same instance, he is only copying over the values in the other spreadsheet.
April 1st, 2015 2:12pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics