| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help: paste special with an operation (add, multiply,...)converts everything to values, pasted formulas & links are lost | Excel Discussion (Misc queries) | |||
| lost my formulas | Excel Discussion (Misc queries) | |||
| How do I keep formulas for being lost when saving in 2007? | Excel Discussion (Misc queries) | |||
| How do I keep a running total of pounds lost and percentage lost | Excel Discussion (Misc queries) | |||
| i have lost the small + that allows mass copy of formulas in excel | Excel Discussion (Misc queries) | |||
Linear Mode
