copy/paste row with one formula

[erika]

I have row with 19 columns and one of these columns contains a formula. I
work with two Excel documents simultaneously and I need to be able to select
an entire row of data from one .xls, copy it, and paste it into a different
Excel .xsl file. When I do this, the pasted row no longer contains my
formula. I am only pasting the formula value on the new file, and not the
formula itself. How do I copy an entire row of data where one column has a
formula, and paste in into a different document while keeping the formula in
tact for that one row?

 

[PhilosophersSage]

Select and copy as usual, but you would r+click the other workbook and selcet
"paste special" and use the "all using source" option.

 

[erika]

Thanks, Sage. I just tried that, but 'paste special' does not show the option
all using source. My options are:
Microsoft Office Excel 2003 Worksheet Object
Picture
Bitmpa
Microsoft Office Excel 2007 Binary Format
Microsoft Excel 8.0 Format
Biff5
SYLK
DIF
XML Spreadsheet
HTML
Unicode Text
Text
Csv
Hyperlink

Also, I am using Excel 2007, but my document is 03 and in compatibility mode
(since I have also found issues with copyiny/pasting from 03 to 07 docs).

 

[Gord Dibben]

You have two instances of Excel running with a workbook in each instance.

Close one insrance and open both workbooks in the single instance.


Gord Dibben MS Excel MVP

 

[erika]

Thanks, Gord. That does work!!!
So I guess it's not possible to do it across instances? I work with dual
monitors and prefer having two instances, one for each screen.

 

[Gord Dibben]

See how Chip Pearson works with dual monitors.

http://www.cpearson.com/excel/MultipleMonitors.aspx

I see nowhere in that description that he opens two instances of Excel.


Gord

 

[erika]

Well you can't get any simpler than that. Thanks for the link Gord!!