'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Not Highlighting Formula References on Other Sheets
Question details
The user needs to resolve an issue where Excel stops displaying visual color highlights for formula cell references located on different worksheets.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Reviewing or editing complex formulas that pull data from multiple different worksheets within the same workbook.
- Observed behavior
- Excel successfully highlights referenced cells on the current active worksheet, but fails to show colored highlights for referenced cells on other worksheets.
Before beginning the troubleshooting steps, save your work and close any unnecessary Excel workbooks to prevent data loss while restarting the application or repairing the software.
Reset Ribbon Customizations and Launch in Safe Mode
Resetting the interface and running Excel in Safe Mode helps identify if the highlighting glitch is caused by a corrupted view setting or a conflicting third-party add-in.
Safe Mode starts Excel with a minimal set of features, disabling COM add-ins and custom toolbars. This is the fastest way to isolate application-level glitches.
Open Excel and click on 'File' > 'Options'. Select 'Customize Ribbon' from the left sidebar, click the 'Reset' dropdown button at the bottom right, and choose 'Reset All Customizations'.
Close Excel completely. Press and hold the 'Ctrl' key on your keyboard, then click the Excel shortcut to launch it. Click 'Yes' when asked if you want to start in Safe Mode.
Create a new blank workbook, add data to two different sheets, and create a cross-sheet formula to see if the cell highlighting behaves normally.
Repair the Microsoft 365 Installation
If Safe Mode does not resolve the issue, repairing the Microsoft Office installation can fix corrupted system files causing cross-sheet formula bugs.
Try WPS Office for Bug-Free Formula Editing
If Microsoft Excel continues to have display issues or requires constant troubleshooting, consider switching to WPS Office. It offers a lightweight, highly stable environment for handling complex spreadsheets and cross-sheet formulas without the visual glitches.
- 1. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Open Your Workbook: Launch WPS Spreadsheet and click 'Open' to load your existing Excel (.xlsx) file.
- 3. Edit Formulas Seamlessly: Click on any formula cell to instantly see accurate, colored visual highlights across all referenced worksheets.
Frequently Asked Questions
Why does Excel highlight references on the same sheet but not other sheets?
This is typically caused by a corrupted application setting, a conflicting COM add-in, or a glitch in the Office installation that breaks the cross-sheet visual debugging interface.
Will resetting Excel customizations delete my macros or data?
No. Clicking 'Reset All Customizations' under the Customize Ribbon menu only restores your ribbon tabs and Quick Access Toolbar to their default layouts. Your macros, VBA code, and workbook data remain perfectly safe.
What is the difference between Quick Repair and Online Repair for Office?
Quick Repair runs fast and fixes most common issues by replacing corrupted files locally without needing an internet connection. Online Repair takes longer and requires an internet connection, as it essentially reinstalls the entire Office suite to resolve deeper system issues.
