I bet you're copying from one workbook to another workbook. But the workbooks
are open in different instances of excel.

Close one instance
Then in the first instance, use File|open to open the second workbook.
Then do the copy|paste special



wduval1715 wrote:

When copying a formula, Excel copies the results of the formula and not the
formula. Also when pasting the Special Paste option brings up options that
are not the same. They are Excel 8, Bitmap instead of Format, Column width,
values and number formats.

--

Dave Peterson