Color formatting issue when copying excel sheet from workbook to o

[Sanjeev]

I have a work book with five excel sheets. I need to copy all five sheets to
new workbook .but when I copy to new workbook the color of the five excel
sheets change it does not maintain it's orginal color.I tried all ways even
copying cell by cell and range still color changes. If any body knows
solution do let me know

 

[Gord Dibben]

The source workbook has had some modifications done to its color palette.

These mods are saved with the workbook.

The new workbook won't have those mods so when you copy the sheets to new
book, the colors will be Excel default colors.

To keep the original colors, with both books open after the sheets have been
copied to new book..............................

In new book go to Tools>Options>Color and "Copy colors from"

Select the source book and OK


Gord Dibben MS Excel MVP