Lost formulas
 

Is there a way to copy and paste formulas from Excel 2003 to Excel 2007?
Right now the data copied from 2003 is pasted as values (all the formulas are
lost)?

Thank you.

Lost formulas
 

Why would you want to do that? Just open the Workbook in 2007.

Deriv001 wrote:

Is there a way to copy and paste formulas from Excel 2003 to Excel 2007?
Right now the data copied from 2003 is pasted as values (all the formulas are
lost)?

Thank you.

Lost formulas
 

Can't open certain files I get from other people in 2007 as there are macros
that are not compatable between the two versions.

"Bob I" wrote:

Why would you want to do that? Just open the Workbook in 2007.

Deriv001 wrote:

Is there a way to copy and paste formulas from Excel 2003 to Excel 2007?
Right now the data copied from 2003 is pasted as values (all the formulas are
lost)?

Thank you.

Lost formulas
 

Sorry, even attempting to copy from one instance of Excel 2007 to
another instance of 2007 results in undesired results.

Deriv001 wrote:
Can't open certain files I get from other people in 2007 as there are macros
that are not compatable between the two versions.

"Bob I" wrote:


Why would you want to do that? Just open the Workbook in 2007.

Deriv001 wrote:


Is there a way to copy and paste formulas from Excel 2003 to Excel 2007?
Right now the data copied from 2003 is pasted as values (all the formulas are
lost)?

Thank you.

Lost formulas
 

Alright, thanks Bob I. If you do discover a way around this, I would
appreciate hearing about it.

"Bob I" wrote:

Sorry, even attempting to copy from one instance of Excel 2007 to
another instance of 2007 results in undesired results.

Deriv001 wrote:
Can't open certain files I get from other people in 2007 as there are macros
that are not compatable between the two versions.

"Bob I" wrote:


Why would you want to do that? Just open the Workbook in 2007.

Deriv001 wrote:


Is there a way to copy and paste formulas from Excel 2003 to Excel 2007?
Right now the data copied from 2003 is pasted as values (all the formulas are
lost)?

Thank you.

Lost formulas
 

try disabling the macros?

Deriv001 wrote:

Alright, thanks Bob I. If you do discover a way around this, I would
appreciate hearing about it.

"Bob I" wrote:


Sorry, even attempting to copy from one instance of Excel 2007 to
another instance of 2007 results in undesired results.

Deriv001 wrote:

Can't open certain files I get from other people in 2007 as there are macros
that are not compatable between the two versions.

"Bob I" wrote:



Why would you want to do that? Just open the Workbook in 2007.

Deriv001 wrote:



Is there a way to copy and paste formulas from Excel 2003 to Excel 2007?
Right now the data copied from 2003 is pasted as values (all the formulas are
lost)?

Thank you.