Install the Formula Audit XL task pane
The task pane edition runs wherever Excel runs — the web, Windows and Mac. It needs no installer: add it from Microsoft AppSource in about a minute, or an admin can push it to everyone. No data leaves your machine.
Get it from Microsoft AppSource
Formula Audit XL is listed on Microsoft AppSource. This is the fastest way in, and it updates by itself.
- 1 In Excel, open any workbook.
- 2 On the Home tab, choose Add-ins.
- 3 Search for “Formula Audit XL”, then choose Add.
- 4 Open the Formula Audit tab and choose any command. In version 1.0 of the listing, choose Audit model on the Home tab.
Or use the manifest URL
https://formulaudit.com/addin/manifest.xml
Use it when you cannot install from the store. To install it yourself, right-click the link, choose “Save link as”, and keep the file — Excel asks you to upload it. An admin pastes the URL straight into the Microsoft 365 admin center.
Same features on Windows, Mac and the web
The task pane has every command of the Windows add-in, on a Formula Audit tab with the same keyboard shortcuts. Three differences:
- Zoom 100 / 85 / 75 works on Windows and Mac only. Excel on the web gives add-ins no zoom control.
- On the web, Quick Navigation is Ctrl+Shift+Alt+N and Number Format Cycle is Ctrl+Shift+Alt+X. The browser keeps the desktop keys.
- Excel 2016 and 2019 get the task pane without the tab and the shortcuts.
For Excel on Windows without a Microsoft account sign-in, use the one-click installer.
What the pane does
- Model Check: the same 15-row report as the desktop, written to a _ModelCheck sheet on request
- Precedent and dependent trees you can drill into, across sheets
- Every audit check: errors, circular references, inconsistent, constant and hardcoded formulas, volatile functions, arrays, merged cells, dead cells, external links and named ranges
- Cell Map and AutoColor, with Undo and your own colours
- Quick Navigation and the utilities: Unhide, Switch Signs, Convert References, Number Format Cycle, Decimals, Gridlines, Headings and Zoom
Sideload it yourself
Use this when your organisation blocks the store. Pick your Excel. No admin rights are needed on the web or on a Mac.
Excel on the web
about a minute- 1 Save the manifest to your computer: right-click the manifest link above and choose “Save link as”.
- 2 Open any workbook at excel.cloud.microsoft (or in Excel on the web through OneDrive or SharePoint).
- 3 On the Home tab, choose Add-ins, then More Add-ins.
- 4 Open the My Add-ins tab and choose Upload My Add-in.
- 5 Choose Browse, pick the manifest.xml you saved, then choose Upload.
- 6 The Formula Audit tab appears. Choose any command, or Open Pane to show the task pane.
An uploaded add-in stays available to you in that browser. Upload it again after you clear site data.
Excel for Windows (desktop)
about five minutes- 1 Put the saved manifest.xml in a folder on a network share you can reach, for example \\server\addins. Excel for Windows only sideloads from a share, not from a local drive.
- 2 In Excel, choose File → Options → Trust Center → Trust Center Settings → Trusted Add-in Catalogs.
- 3 Paste the share path into Catalog Url, choose Add catalog, then tick Show in Menu.
- 4 Choose OK twice and restart Excel.
- 5 Choose Home → Add-ins → More Add-ins → Shared Folder, pick the add-in, and choose Add.
On a managed laptop you may not be able to add a trusted catalogue. Ask your admin to use Centralized Deployment below, or install the Windows installer instead.
Excel for Mac
about two minutes- 1 Open Finder and press ⇧⌘G, then go to ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef. Create the wef folder if it is not there.
- 2 Copy the saved manifest.xml into that folder.
- 3 Quit Excel completely and reopen it.
- 4 Choose Home → Add-ins → My Add-ins, then pick Formula Audit XL.
The Windows .xlam installer does not run on a Mac. The task pane is the Mac edition.
Deploy it across your organisation
Microsoft 365 Centralized Deployment puts the pane in every user’s Excel — web, Windows and Mac — without anyone touching a file. It needs no software on the endpoint.
In Integrated apps, choose Get apps and search for “Formula Audit XL” to deploy the AppSource listing. To deploy from the manifest URL instead, follow these steps:
- 1 Sign in to admin.microsoft.com as a Global Administrator or an Exchange Administrator.
- 2 Choose Settings → Integrated apps, then Upload custom apps.
- 3 Choose App type: Office Add-in.
- 4 Choose “Provide link to manifest file” and paste https://formulaudit.com/addin/manifest.xml.
- 5 Choose who gets it: Just me, Entire organization, or specific users and groups.
- 6 Review the requested permissions (read and write the open workbook — nothing else), then choose Deploy.
Microsoft can take up to 24 hours to propagate a new deployment to every client. Because the deployment points at a URL, updates reach your users without a second upload.
Requirements
- Excel on the web, Excel for Windows 2016 or later, or Excel for Mac
- The Formula Audit tab and the shortcuts need Microsoft 365, Excel 2021 or later, or Excel on the web
- A Microsoft 365 or Office account signed in to Excel
- No installer, no admin rights, no macros
- The pane reads the open workbook only — no file is uploaded
Trial and licence
- The pane starts a 7-day trial the first time you open it
- Paste your licence key into the pane to keep it
- One key, both editions — a single-seat key runs on one of them at a time
- See plans →
The pane will not open, or opens blank? Check that your network allows
formulaudit.com and Microsoft’s add-in CDN, then
contact us — we answer every message.
Auditing on Windows instead?
For Microsoft Excel on Windows, Mac and the web · No data leaves your machine