Copy and paste

[Carl]

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

 

[Carroll]

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

 

[Gord Dibben]

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

 

[Carl]

Thank you.

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