Dec 01 2023 03:40 AM
Hi! We use a shared document to import data. We have a lot of different tabs, colours and informations on it, which is really important it stays that way, it is updated 100x per day between 10 people.
However lately when someone opened the excel file the colours of the cells changes automatically to colour what we dont use, there is usually between 1-3 different colours per cells. Some cells also change font when clicking on it then back to normal when we click on another cell. We have tried to create new file with new cells but nothing works.
Dec 01 2023 08:35 AM
When you encounter issues with colors and fonts changing automatically in a shared Excel file, it can be frustrating, but there are several potential causes and solutions you can explore:
1. Compatibility Mode:
2. Conditional Formatting:
3. Default Excel Template:
4. Styles and Themes:
5. Workbook Sharing:
6. Check for External Add-ins:
7. Cell Styles:
8. Cell Protection:
9. Review Changes:
10. Update Office:
- Ensure that all users are using the latest version of Microsoft Office. Sometimes, updating Office can resolve compatibility issues.
11. Backup and Repair:
- Make a backup of the file and try repairing it. Go to "File" > "Info" > "Manage Workbook" > "Recover Unsaved Workbooks" or use the "Open and Repair" option.
12. User-Specific Settings:
- Check if the issue is user-specific. If possible, try opening the file on a different computer to see if the issue persists.
If the issue persists after trying these steps, it may be a complex problem, and you may need to involve your IT support for a more in-depth investigation into the file and its behavior.
The text and steps were edited with the help of AI.
This text is intended to help you investigate possible sources of error.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.