Really don't know what's happening over there <g, but as a last attempt,
try the alternative to right-clicking on A1 in the new sheet as per below
(my ver is Excel 97)

(Do hang around awhile here for better insights from others ..)

In a new Sheet1 in a new book,

Instead of
Right-click on A1 Paste special Check "Values" OK

With A1 selected,
click Edit Paste special check "Values" OK

If you need to copy over the formats as well, then just do one mo

Instead of
Right-click on A1 Paste special Check "Formats" OK

With A1 selected,
click Edit Paste special check "Formats" OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"BG" wrote in message
...
Hi Max,

Again, thank you for your help and I understand your comments. However,
when I

"Right-click on A1 Paste special Check "Values" OK"

I do not see the "normal" Paste Special options of All, Formulas, Values,
etc.

I see a Paste Special window with:

Source: C:\Documents and Settin...\Test.xls Sheet1:R1:R65536 with "Paste"
and "Paste link:" radio buttons and a "As:" window with

Microsoft Excel Worksheet object
Picture
Bitmap
etc.

I am running Excel 2002 (10.6501.6735) SP3

Again, thank you.

BG