Copy and paste
 

Working with the new excel I have a spreadsheet with formulas. When I copy
the sheet to a new workbook ALL the formulas are gone and only the raw data
is there. I have tried ALL the paste specials and nothing has worked. I
have had to re-type all my formulas. In the 2003 ver. everything would copy
over.

Any help would be great

Thank you,
Carl

Copy and paste
 

Carl,
Try copying the sheet to a new workbook by right-clicking on the worksheet
tab, selecting Move or Copy, click the Copy box in the bottom left, then
chose (new book) in the "To book:" drop down menu.

Carroll


"Carl" wrote:

Working with the new excel I have a spreadsheet with formulas. When I copy
the sheet to a new workbook ALL the formulas are gone and only the raw data
is there. I have tried ALL the paste specials and nothing has worked. I
have had to re-type all my formulas. In the 2003 ver. everything would copy
over.

Any help would be great

Thank you,
Carl

Copy and paste
 

If you have two workbooks open in separate instances of Excel you will have
this problem.

Open both books in one instance.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 15:00:02 -0800, Carl
wrote:

Working with the new excel I have a spreadsheet with formulas. When I copy
the sheet to a new workbook ALL the formulas are gone and only the raw data
is there. I have tried ALL the paste specials and nothing has worked. I
have had to re-type all my formulas. In the 2003 ver. everything would copy
over.

Any help would be great

Thank you,
Carl

Copy and paste
 

Thank you.

"Carroll" wrote:

Carl,
Try copying the sheet to a new workbook by right-clicking on the worksheet
tab, selecting Move or Copy, click the Copy box in the bottom left, then
chose (new book) in the "To book:" drop down menu.

Carroll


"Carl" wrote:

Working with the new excel I have a spreadsheet with formulas. When I copy
the sheet to a new workbook ALL the formulas are gone and only the raw data
is there. I have tried ALL the paste specials and nothing has worked. I
have had to re-type all my formulas. In the 2003 ver. everything would copy
over.

Any help would be great

Thank you,
Carl