You can use Tools - Options the the Color tab to copy the color scheme
from one sheet to another. That may help you.

Good luck.

Ken
Norfolk, Va

On Jun 22, 3:53 pm, Margie wrote:
I have a software program that exports Excel 97 files. When I copy a
worksheet from the Excel 97 format and insert the worksheet into an Excel
2000 file, the colors don't copy over.

The Excel 97 files have only limited colors (16 total). If I change the
color scheme on the Excel 97 to match, the colors go all wild and crazy.

Anybody had to deal with this before?