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

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.

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.