Help: Pasting between Excel workbook instances 2007

V

Vulcan

Hoping that someone can remember how to fix this.

In previous versions of Excel, I found that I couldn't past between
workbooks. I think, but can't remember for sure, that the problem was
resolved by adding a command line switch to start up new instances of Excel
in such a way that data and formulas could be pasted between any open
instances.

Now that I've switched to Excel 2007 the problem is back! I took a look at
the command line switch options but couldn't find anything that looks like
it'll do the job. Anyone remember how to fix this? Thanks.
 
P

Peo Sjoblom

Are you saying you can't paste between workbooks in Excel 2007?

What does that mean? When you copy you will not get an option to paste?

--


Regards,


Peo Sjoblom
 
G

Gord Dibben

I think you have it backwards.

In older versions of Excel you could not paste formulas between workbooks
opened in two separate instances of Excel.

The formulas would revert to values.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Instances of Excel on 64-bit Win7 1
Pasting a chart as object between instances of Excel 5
Multiple instances of Excel (Multiple workbooks) 3
'.Copy Destination:=' temporarily freezes multiple instances in Excel 2010 2
Excel 2007 "Can not shift objects off sheet" 4
SLOW Response on EXCEL 2003 6
Unable to switch to SDI in Excel 2007 0
Switch to Excel workbook in a separate instance of Excel 3

Top