Prev: Leading zero's trail Number
Next: H and V lookup or match?
From: squintana on 6 Apr 2010 16:49
I am using Excel 2007 and I can't seem to copy and paste formulas from one
workbook to another. Instead I get a dialogue box asking me if I want to use
paste or paste link and to chose from a list of formats. Does anyone know if
there is something that I can change in Excel to fix this problem?
From: Dave Peterson on 6 Apr 2010 17:04
It sounds like you have the workbooks open in separate instances of excel.

Close one of the workbooks (and its instance of excel) and then back to the
first workbook/excel.

Hit ctrl-o and open your second workbook and try the copy|paste.

squintana wrote:
>
> I am using Excel 2007 and I can't seem to copy and paste formulas from one
> workbook to another. Instead I get a dialogue box asking me if I want to use
> paste or paste link and to chose from a list of formats. Does anyone know if
> there is something that I can change in Excel to fix this problem?

--

Dave Peterson
From: Joe User on 6 Apr 2010 19:41
"squintana" <squintana(a)discussions.microsoft.com> wrote:
>I am using Excel 2007 and I can't seem to copy and paste formulas from one
> workbook to another. Instead I get a dialogue box asking me if I want to
> use
> paste or paste link and to chose from a list of formats. Does anyone know
> if
> there is something that I can change in Excel to fix this problem?

Are both workbooks open in the same instance of Excel?

I find it difficult to know when that it is actually the case. To be sure,
I use File > Open to open the second workbook instead of clicking on the
file icon.

From: Joe User on 6 Apr 2010 19:48
Oops.... I didn't see Dave's posting with the same information nearly 3(!)
hrs ago. Mea culpa!


----- original message -----

"Joe User" <joeu2004> wrote in message
news:e5N20Ke1KHA.6108(a)TK2MSFTNGP06.phx.gbl...
> "squintana" <squintana(a)discussions.microsoft.com> wrote:
>>I am using Excel 2007 and I can't seem to copy and paste formulas from one
>> workbook to another. Instead I get a dialogue box asking me if I want to
>> use
>> paste or paste link and to chose from a list of formats. Does anyone
>> know if
>> there is something that I can change in Excel to fix this problem?
>
> Are both workbooks open in the same instance of Excel?
>
> I find it difficult to know when that it is actually the case. To be
> sure, I use File > Open to open the second workbook instead of clicking on
> the file icon.

 | 
Pages: 1
Prev: Leading zero's trail Number
Next: H and V lookup or match?