How to install Analysis Toolpak on Mac?

Since activation and restarting have already failed, test Excel from a new local macOS user account to determine whether the disappearing ToolPak setting is confined to your current Excel profile.

1. Test from a new macOS user account

1. Open System Settings → Users & Groups.
2. Add a temporary local user, then sign out of your current account and sign in to the new one.
3. Open Excel and sign in to Microsoft 365 if requested.
4. Select Tools → Excel Add-ins.
5. Check Analysis ToolPak, select OK, and quit Excel.
6. Reopen Excel and check Data → Data Analysis.

Data Analysis is the expected command; the ToolPak does not appear as a separate ribbon tab. Microsoft’s documented Mac procedure confirms that it should appear on the Data tab after activation and restart.^1^

• If it remains enabled in the new account: the problem is isolated to preferences or application data in the original macOS account.
• If it also becomes unchecked there: the issue is application-wide. Proceed to the reinstall fallback below.

Microsoft’s current Excel for Mac known-issues page does not list a known issue specifically involving the Analysis ToolPak checkbox failing to persist.^2^

2. If this is a school-managed Mac

Before resetting Office, ask your school’s IT administrator to test the same operation or check whether Office settings are being managed. Do not attempt to remove management profiles yourself.

Provide IT with these observations:

• Analysis ToolPak is available and can initially be checked.
• No installation prompt or error appears.
• The checkbox clears after Excel is reopened.
• Data Analysis never appears on the Data tab.

3. Last resort: completely remove and reinstall Office

A complete removal is not documented as a confirmed fix for this exact ToolPak symptom, but it is the available last-resort reset if the failure also occurs in a new macOS account.

Warning: This resets Office application data and preferences. Administrator credentials are required. If Outlook is installed, back up its data before removing any Outlook-related containers.

Follow Microsoft’s complete removal procedure rather than only dragging Excel to the Bin:^3^

1. Close all Office applications.
2. Open Finder → Applications and move the Microsoft 365 applications to the Bin.
3. In Finder, press Command+Shift+G, enter ~/Library, and select Go.
4. Follow the linked Microsoft article to remove the listed Office items from both:
   • Containers
   • Group Containers
5. Restart the Mac.
6. Reinstall and activate Microsoft 365.
7. Return to Tools → Excel Add-ins, check Analysis ToolPak, and select OK.
8. Quit and reopen Excel, then look for Data → Data Analysis.^1^

If the setting still disappears after a complete reinstall and also fails in a separate macOS account, contact Microsoft Support with the Excel version from Excel → About Microsoft Excel, the macOS version, and whether Excel came from the Mac App Store or Microsoft’s installer.

References

1. Load the Analysis ToolPak in Excel
2. Fixes or workarounds for recent issues in Excel for Mac | Microsoft Support
3. Uninstall Office for Mac | Microsoft Support