| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
| Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Linear Mode
