How to Fix Excel Status Bar Not Copying Sum or Average
Question details
The user is unable to copy summary values like sum, average, or count from the Excel status bar to the clipboard.

- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- not provided
- Scenario
- Trying to quickly copy calculated data (sum, average, count) from selected cells using the interactive status bar feature after a recent update.
- Observed behavior
- Clicking on the status bar summary values does nothing, and the selected values fail to copy to the system clipboard.
Before troubleshooting, ensure you have an active internet connection to download any pending Microsoft 365 updates, and save all open workbooks to prevent accidental data loss during a restart.
Update Microsoft 365 and Repair the Office Installation
Updating to the latest build often resolves known bugs introduced in previous versions, while an online repair fixes corrupted core application files.
Microsoft frequently releases patches to fix bugs related to the clipboard and user interface. If an update broke the status bar feature, a subsequent hotfix is likely available.
If updating does not work, the Office installation itself may have become corrupted during the update process, requiring a repair.
Open Excel, navigate to File > Account, click on 'Update Options', and select 'Update Now' to install the latest Microsoft 365 build.
If the issue persists after updating, close Excel, press the Windows key, type 'Control Panel', and open it. Navigate to 'Programs and Features'.
Find Microsoft 365 in the list of installed programs, right-click it, select 'Change', choose 'Online Repair', and click 'Repair'. Follow the on-screen prompts and restart your PC.

Run Excel in Safe Mode to Disable Incompatible Add-ins
Third-party add-ins can interfere with clipboard operations and status bar functionality. Safe mode helps isolate the problem by launching Excel without them.
Perform a Windows Clean Boot
Background applications, particularly clipboard managers or overzealous antivirus software, can lock the clipboard and conflict with Excel's copy function.
Try WPS Office to Avoid Update Bugs and Performance Issues
If Microsoft Excel's status bar keeps failing after updates or struggling with clipboard conflicts, consider switching to WPS Spreadsheet. It is a highly stable, free, and lightweight alternative that offers seamless compatibility with all Microsoft Office formats, allowing you to view, calculate, and copy your data without interruptions.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing Excel (.xlsx) files directly.
- 3. Use the Status Bar: Highlight the cells you want to calculate. Instantly view the Sum, Average, or Count on the bottom status bar and use standard copy shortcuts seamlessly.

Frequently Asked Questions
Why did the Excel status bar copy feature stop working suddenly?
This usually happens due to a bug introduced in a recent Microsoft 365 update. It can also be caused by corrupted Office installation files, or a conflict with a newly installed third-party Excel add-in that locks the system clipboard.
Can I customize what shows on the Excel status bar?
Yes. Right-click anywhere on the blank space of the status bar at the bottom of the Excel window. A 'Customize Status Bar' menu will appear where you can check or uncheck summary options like Average, Count, Numerical Count, Minimum, Maximum, and Sum.
Does a clipboard manager affect Excel's ability to copy data?
Yes, third-party clipboard managers or remote desktop utilities can temporarily lock the Windows clipboard, preventing Excel from successfully copying the summary data from the status bar. Temporarily disabling the clipboard manager can resolve the issue.
How can I manually copy the sum if the status bar fails?
If the status bar is completely unresponsive, you can use a formula as a workaround. Type '=SUM(range)' in an empty cell, press Enter, and then copy the calculated result from that cell using Ctrl+C.




