Why does sheet formatting change when pasting into a new book?

C

CSchwass

When I select Move/Copy... for a sheet in Excel 2007 and select a new
workbook, sometimes the formatting changes. Usually the charts will have a
new color scheme, and cell colors will change to strange color schemes as
well (bright red and green, anyone?). I am copying from one XLSX file to
another, both files are open at the time, and there are no macros enabled or
grouped sheets.

How can I retain the formatting, and what is causing this issue? Several of
my colleagues experience the same issue with reports.

Thanks,
Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting change after pasting into a new weoksheet 1
Keep destination formatting when pasting? 2
Formatting not protected when paste 7
Formatting lost when copy pasting 1
Why do dates change when I copy/paste into another sheet? 1
Preserve the formatting of a cell when pasting into it 3
Cell fill colors in Excel change when copying to a new book 2
how to change color gradients in a bar chart 0

Top