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?

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" wrote:

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?

Thanks, Sage. I just tried that, but 'paste special' does not show the option
all using source. My options a
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).

"PhilosophersSage" wrote:

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" wrote:

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?

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

On Tue, 29 Sep 2009 11:30:02 -0700, erika
wrote:

Thanks, Sage. I just tried that, but 'paste special' does not show the option
all using source. My options a
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).

"PhilosophersSage" wrote:

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" wrote:

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?

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" wrote:

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

On Tue, 29 Sep 2009 11:30:02 -0700, erika
wrote:

Thanks, Sage. I just tried that, but 'paste special' does not show the option
all using source. My options a
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).

"PhilosophersSage" wrote:

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" wrote:

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?

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

On Tue, 29 Sep 2009 15:32:11 -0700, erika
wrote:

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" wrote:

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

On Tue, 29 Sep 2009 11:30:02 -0700, erika
wrote:

Thanks, Sage. I just tried that, but 'paste special' does not show the option
all using source. My options a
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).

"PhilosophersSage" wrote:

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" wrote:

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?