Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Copy sheet to new book changes cell color

Copper Contributor

We have a company wide report that is used every day that utilizes a macro which copies two sheets to a new workbook once it is done running. We noticed this morning that certain cell colors are completely changing when opened in a new book. 


The original file has all of the colors the way we want, but once moved to its own book, we get things like "Gold, Accent 4, Lighter 80%" changing to "Turquoise, Accent 4, Lighter 80%". I can see that the available color selection has changed for fill, but we have the colors set up in a specific manner and need them to hold their original fill. 

Any ideas on what we could do to fix this?

1 Reply
The theme for the whole file is changing when sheets are copied to new workbook. New Question: Why does it auto update the theme and is there a way to get it to stop doing that?