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?