Can't Copy and Paste foumulas?
I am trying to copy an unprotected worksheet
and paste it into another worksheet. All of the text gets pasted but the formulas do not. When I try Paste Special the dialog box offers to paste a 'Microsoft Excel Worksheet Object'. And if I try to copy and paste only one cell which contains a formula the same happens. Why is this happening? And is there a way I can paste the cell contents which are formulas? Thank you, Emory |
Instead of coping all the cells of one worksheet into another, just copy the
worksheet itself: Edit Move or Copy Sheet... -- Gary''s Student "Emory Richter" wrote: I am trying to copy an unprotected worksheet and paste it into another worksheet. All of the text gets pasted but the formulas do not. When I try Paste Special the dialog box offers to paste a 'Microsoft Excel Worksheet Object'. And if I try to copy and paste only one cell which contains a formula the same happens. Why is this happening? And is there a way I can paste the cell contents which are formulas? Thank you, Emory |
|
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com