2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Certain files don't let me change themes after a while

Our take

Experiencing issues with changing theme colors in your spreadsheet can be frustrating, especially when it seems to happen randomly across various files. Despite having the menu options available and the ability to modify other elements like colors and fonts, the theme itself remains unchangeable. This peculiar behavior isn't linked to permissions, file age, or storage type, as it can occur in both online and locally stored files. If you've encountered this baffling problem, you're not alone. Let’s explore potential solutions together.

Hi, this is a strange one. I am using lots of custom theme colours and sometimes need to change or update them, and some files will randomly stop letting me do that for seemingly no reason.

When broken, I can do everything else, including changing colours (or fonts etc.) manually, or with conditional formatting, but I cannot change the theme itself. The menu options are there, the themes aren't greyed out, yet they cannot be applied. I can right-click on them and edit them, but it changes nothing. I can even customise the existing theme, but that takes no effect either.

All files are my own with the same permissions. Some are online, some locally stored; some are shared, some are not, the issue can occur irrespective of any of these factors, nor is it tied to the age or size of the file. When I create a new workbook it always works. Old workbooks either do or don't, and if one has been 'corrupted' it will never work again. The issue persists across all sheets within a workbook. I can manually copy the contents of each sheet into a completely new workbook and it will work again, but it can also break again in the future. I cannot break it on purpose, and even when I once noticed it occurring during editing the only thing I could do was to revert to an old version of the file, I couldn't find what specific thing caused it using undo (although it is possible that if caught quickly I could undo it, but I usually notice it a few sessions later by which point it is too late)

I am honestly baffled by this. Has anyone any idea?

submitted by /u/Raasquart
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel alternatives for data analysis#financial modeling with spreadsheets#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#google sheets#Excel alternatives#custom theme colours#change the theme#theme not applied#changing colours#workbooks#conditional formatting#corrupted#revert to old version#menu options#edit theme#version of the file#persist across sheets