I've created some spreadsheets that others use. The headings of the spreadsheets are divided up with colors. However after I've created these and saved them formatted as I like, some of these cells are changing automatically after the other users open them up.

I've read online there may have been custom formatting done originally. So I've gone in and deleted all of the "custom" formatting available. If then changed the column headings back to the formatting I prefer. But again, as the user is opening it the next day, these handful of column heading go back to a white background with a change in font and font size.

Any ideas what could cause this? More importantly, how do I fix it?

In advance, thanks for your help.


1 Year
Discussion Span
Last Post by Hanif1993

ddanbe, That definately isn't the issue. All of our computers are loaded with the "standard issue" fonts and all are exactly the same. Specifically, the heading are saved with the "Calibri" size 10 font. It is converting back to "Arial" size 6 - but only on a handful of cells. It is not across the page. If I didn't no better, I'd say those specific cells are programmed to change (either programmatically or through Conditional Formatting". But I see no indication of either anywhere.

I'm at a loss.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.