ExcelBanter - Copy between workbooks error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy between workbooks error (https://www.excelbanter.com/excel-discussion-misc-queries/151508-copy-between-workbooks-error.html)

Mike Fitz

Copy between workbooks error

I am coping between 2003 Excel file to 2007 Excel file. The formuals are
becoming values. I am not pasting special as a value. How do I keep my
formulas?

Dave Peterson

Copy between workbooks error

Open both workbooks in a single instance of xl2007.

Mike Fitz wrote:

I am coping between 2003 Excel file to 2007 Excel file. The formuals are
becoming values. I am not pasting special as a value. How do I keep my
formulas?

--

Dave Peterson

Mike Fitz[_2_]

Copy between workbooks error

Worked great! Your the man with the answers

"Dave Peterson" wrote:

Open both workbooks in a single instance of xl2007.

Mike Fitz wrote:

I am coping between 2003 Excel file to 2007 Excel file. The formuals are
becoming values. I am not pasting special as a value. How do I keep my
formulas?

--

Dave Peterson

All times are GMT +1. The time now is 09:46 PM.