cancel
Showing results for 
Search instead for 
Did you mean: 

Excel 2K how to copy cells from a saved workbook into to another being created?

Luzern
Seasoned Pro
Posts: 3,157
Thanks: 303
Fixes: 2
Registered: 31-07-2007

Excel 2K how to copy cells from a saved workbook into to another being created?

I have a saved workbook and want to use certain cells from it to use in another I an creating, Selecting copy in one and Paste or Paste Special in the being created one does not work, as the Paste options are greyed.
Is there a way to do what I want simply? BTW VBA is something of which I am extremely ignorant and so I would prefer to avoid.
No one has to agree with my opinion, but in the time I have left a miracle would be nice.
3 REPLIES
pierre_pierre
Grafter
Posts: 19,757
Registered: 30-07-2007

Re: Excel 2K how to copy cells from a saved workbook into to another being created?

try opening a new sheet, make a dummy entry then paste
Community Veteran
Posts: 38,460
Thanks: 1,027
Fixes: 62
Registered: 15-06-2007

Re: Excel 2K how to copy cells from a saved workbook into to another being created?

you need to use the Paste Link command - with both workbooks open.
If you then close the workbook where the link came from the link changes to show the complete path
http://office.microsoft.com/en-us/excel/HA010548121033.aspx
Luzern
Seasoned Pro
Posts: 3,157
Thanks: 303
Fixes: 2
Registered: 31-07-2007

Re: Excel 2K how to copy cells from a saved workbook into to another being created?

Thank you Smiley
No one has to agree with my opinion, but in the time I have left a miracle would be nice.