"Al" wrote in message
...
I'm working in EXCEL 2002, and I have a workbook that someone created with
about 1000 records. When I copy a range of cells to a blank workbook,
they
all come out with a formatting pattern that hides all the data
(essentially
black). If I paste the same range of cells anywhere in the original
workbook
everything works normally. If I match the destination formatting in the
new
workbook, it comes out fine there also. There is no conditional
formatting
set anywhere. My question is...why does this happen?

What do you mean by "essentially black"? Rectangular cells fill with a black
pattern???

Can you provide a few samples of the actual data?