Fix Excel Ctrl+Z Not Undoing Formula Changes from Add-ins
Question details
The user is unable to use the Ctrl+Z undo function to revert formula changes supplied by an Excel add-in (such as EVE Online), and Excel sometimes fails to recognize the add-in formulas completely.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Editing a workbook using custom formulas provided by a third-party add-in and attempting to undo recent changes.
- Observed behavior
- The Ctrl+Z shortcut does not undo the changes made by the add-in formulas, and in some Windows profiles, Excel fails to detect the formulas even when the add-in is visibly loaded.
Save your current workbook progress manually and ensure you have administrative privileges on your Windows account, as troubleshooting this issue may require modifying Trust Center settings or testing a new user profile.
Verify and Reinstall the Excel Add-in
Refreshing the add-in installation ensures that background scripts or outdated versions are not interfering with Excel's undo stack.
Some third-party add-ins run background macros that inadvertently clear Excel's undo history whenever a calculation is triggered. Reinstalling and updating the add-in can resolve bugs causing this behavior.
Launch Microsoft Excel, navigate to the 'Insert' tab on the top ribbon, and click on 'My Add-ins'.
Locate the specific add-in (e.g., EVE Online) in the list, click the three-dot menu icon in the top-right corner of its card, and select 'Remove'.
Click 'Store' within the Add-ins window, search for the add-in again, and click 'Add'. Ensure you are installing the latest version provided by the developer.
Go to File > Options > Add-ins. At the bottom, change the 'Manage' dropdown to 'Disabled Items' and click 'Go' to ensure the add-in wasn't blocked by Excel's crash handler.
Adjust Workbook Security and Trusted Locations
Excel's strict security settings can block certain add-in formulas from executing correctly, disrupting normal application behaviors like the undo function.
Test on a Different Windows Profile
Since add-in detection issues are often isolated to a corrupted local Windows user profile, testing on a new account can pinpoint the root cause.
Try WPS Office for Seamless Spreadsheet Management
If persistent add-in compatibility issues and undo failures in Microsoft Excel are disrupting your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that reliably handles complex formulas and everyday data tasks.
- 1. Download and Install: Visit the official WPS Office website to download the free installer and complete the quick installation process.
- 2. Open Your Workbook: Launch WPS Spreadsheets and click File > Open to seamlessly load your existing Excel files.
- 3. Work Without Interruptions: Edit your data and formulas with reliable action tracking, ensuring your Ctrl+Z shortcut always works exactly as expected.
Frequently Asked Questions
Why does Ctrl+Z stop working when using Excel add-ins?
Many Excel add-ins use background VBA scripts or complex macros to pull in data. Running these macros inherently clears Excel's Undo stack, which disables the ability to use Ctrl+Z for recent actions.
How can I tell if an add-in is the cause of my Excel issues?
You can isolate the issue by running Excel in Safe Mode. Press and hold the Ctrl key while clicking the Excel shortcut, and confirm you want to start in Safe Mode. If Ctrl+Z works normally, an active add-in is likely interfering.
Can a corrupted Windows user profile affect Excel add-ins?
Yes. Add-ins rely on specific registry keys and AppData folders tied to your local Windows user profile. If these become corrupted or have permission issues, Excel may fail to load the add-in properly or recognize its formulas.
