ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy paste between two instances does not work (https://www.excelbanter.com/excel-discussion-misc-queries/101327-copy-paste-between-two-instances-does-not-work.html)

[email protected]

copy paste between two instances does not work
 
Dear Excel experts,

Sometimes when I copy cells from one Excel to the next the formulas
get's lost.


I select some cells contain some formulas and press copy in on
worksheet in one Excel session.
I select past in another worksheet in another Excel session.
Only values are copied over but the formulas are lost!


Regards
Lars Schouw


Dave Peterson

copy paste between two instances does not work
 
Don't open the workbooks in separate instances of excel--open each workbook in a
single instance of excel.

Open the first anyway you want, then use File|open to open the second.

wrote:

Dear Excel experts,

Sometimes when I copy cells from one Excel to the next the formulas
get's lost.

I select some cells contain some formulas and press copy in on
worksheet in one Excel session.
I select past in another worksheet in another Excel session.
Only values are copied over but the formulas are lost!

Regards
Lars Schouw


--

Dave Peterson

[email protected]

copy paste between two instances does not work
 
Is there any hope that this bug will be fixed in Excel 2007?
Lars

Dave Peterson wrote:
Don't open the workbooks in separate instances of excel--open each workbook in a
single instance of excel.

Open the first anyway you want, then use File|open to open the second.

wrote:

Dear Excel experts,

Sometimes when I copy cells from one Excel to the next the formulas
get's lost.

I select some cells contain some formulas and press copy in on
worksheet in one Excel session.
I select past in another worksheet in another Excel session.
Only values are copied over but the formulas are lost!

Regards
Lars Schouw


--

Dave Peterson



Dave Peterson

copy paste between two instances does not work
 
I don't think it's a bug. One instance of excel doesn't know about the second
instance--so you're really going through the windows clipboard--instead of
excel's.



wrote:

Is there any hope that this bug will be fixed in Excel 2007?
Lars

Dave Peterson wrote:
Don't open the workbooks in separate instances of excel--open each workbook in a
single instance of excel.

Open the first anyway you want, then use File|open to open the second.

wrote:

Dear Excel experts,

Sometimes when I copy cells from one Excel to the next the formulas
get's lost.

I select some cells contain some formulas and press copy in on
worksheet in one Excel session.
I select past in another worksheet in another Excel session.
Only values are copied over but the formulas are lost!

Regards
Lars Schouw


--

Dave Peterson


--

Dave Peterson

[email protected]

copy paste between two instances does not work
 
Why is that a problem?
Lars

Dave Peterson wrote:
I don't think it's a bug. One instance of excel doesn't know about the second
instance--so you're really going through the windows clipboard--instead of
excel's.



wrote:

Is there any hope that this bug will be fixed in Excel 2007?
Lars

Dave Peterson wrote:
Don't open the workbooks in separate instances of excel--open each workbook in a
single instance of excel.

Open the first anyway you want, then use File|open to open the second.

wrote:

Dear Excel experts,

Sometimes when I copy cells from one Excel to the next the formulas
get's lost.

I select some cells contain some formulas and press copy in on
worksheet in one Excel session.
I select past in another worksheet in another Excel session.
Only values are copied over but the formulas are lost!

Regards
Lars Schouw

--

Dave Peterson


--

Dave Peterson



Dave Peterson

copy paste between two instances does not work
 
If you want to see the other paste special menu, then it's a problem.

If you like to see the values, then it's not a problem.



wrote:

Why is that a problem?
Lars

Dave Peterson wrote:
I don't think it's a bug. One instance of excel doesn't know about the second
instance--so you're really going through the windows clipboard--instead of
excel's.



wrote:

Is there any hope that this bug will be fixed in Excel 2007?
Lars

Dave Peterson wrote:
Don't open the workbooks in separate instances of excel--open each workbook in a
single instance of excel.

Open the first anyway you want, then use File|open to open the second.

wrote:

Dear Excel experts,

Sometimes when I copy cells from one Excel to the next the formulas
get's lost.

I select some cells contain some formulas and press copy in on
worksheet in one Excel session.
I select past in another worksheet in another Excel session.
Only values are copied over but the formulas are lost!

Regards
Lars Schouw

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com