I don't understand.

Are you saying that if you open a new workbook and try copying from one cell in
Sheet1 to another cell in Sheet1 (same workbook), then you get that funny paste
special dialog?

If you mean that happens, then a guess--Do you have any special windows
clipboard software running in the background?

If I remember correctly, someone posted with a similar problem and found the
answer himself/herself, but posted back that another program was interrupting
that Edit|copy function.

If you close all other open applications, does excel still react this same way?

Joe VW wrote:

It doesn't matter. When I first load Excel and use the first blank
spreadsheet (not loading anything), it still acts the same way. I can't even
select a range of cells and click another cell and copy - it will only copy
into the first cell. Before, it would copy the whole range without me doing
anything special. I am really baffled. I can't use Excel the way it is
behaving.

"Dave Peterson" wrote:

You have two instances of excel running.

Close one workbook and that instance of excel.
Then in the remaining instance, do File|open to open that other workbook.

Then try your copy|paste special.

Joe VW wrote:

I used to be able to right-click on a cell, copy then right-click on another
cell and choose from a dialog box either 'all', 'formulas', 'value',
'formats', etc., but now all that comes up is a dialog box asking if I want
to paste as 'Unicode Text' or 'Text'. How do I get back the original Paste
Special dialog box?

--

Dave Peterson


--

Dave Peterson