After I use DATA/SUBTOTALs, columns, I click the outline level 2
symbol (at the left of the spreadsheet) to see only the totals and the
grand total.

I then choose a range of cells, click "Go To Special", click "Visible
Cells Only" and click COPY.

On a different spreadsheet, when I click "PASTE SPECIAL", instead of a
box with:
All
Formulas
Values
Formats
etc.

the box lists:
Microsoft Office Excel Worksheet Object
Picture (Enhanced Metafile)
Bitmap
etc.

How do I PASTE SPECIAL VALUES?