Copy and paste

  • Thread starter Thread starter Carl
  • Start date Start date
C

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
 
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
 
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
 
Thank you.

Carroll said:
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
Click to expand...
 
Back
Top