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