Excel - Paste Special Values Question

[Quanchi]

Ok......I need some help. I am using Office XP, service pak 2.

In Excel, I highlight information, right click and select copy. If
go to another sheet in the same workbook and right click and selec
Paste Special values, I get the the Paste Special Values Menu.

[image: http://www.mrexcel.com/mec000526a.gif]


If I go to a new workbook, right click and select Paste Special Values
I get a differen't Paste Special Values screen. On the new screen,
have tried each option and nothing works.

[image: http://excelhelp.freeservers.com/special_values_error.gif]

Any ideas on why it is doing this? Is there a setting?


Thanks in advance,

Quanch

 

[Debra Dalgleish]

Perhaps you're opening another instance of Excel (e.g. double-clicking
the Excel icon on your desktop), rather than just creating a new
workbook (in Excel, click the New button on the toolbar).

If so, you'd see the Paste Special dialog box in your second screen shot.

Ok......I need some help. I am using Office XP, service pak 2.

In Excel, I highlight information, right click and select copy. If I
go to another sheet in the same workbook and right click and select
Paste Special values, I get the the Paste Special Values Menu.

[image: http://www.mrexcel.com/mec000526a.gif]


If I go to a new workbook, right click and select Paste Special Values,
I get a differen't Paste Special Values screen. On the new screen, I
have tried each option and nothing works.

[image: http://excelhelp.freeservers.com/special_values_error.gif]

Any ideas on why it is doing this? Is there a setting?