Last Updated: September 23, 2022
ISSUE
Excel for the web may not show the Insert PivotTable button in the ribbon in the following cases:
-
A workbook stored in OneDrive or SharePoint opened anonymously (not logged in) from a link set to “Anyone with the link can edit”.
-
A workbook stored in an external storage service like box.com or dropbox.com and opened in Excel for the web
STATUS: FIXED
The issue is fixed in Excel for the web, Build 16.0.15718.37962 or above. It was released to Production on Wednesday, September 21, 2022.
More Resources
![Icon Experts (brain, gears)](https://support.content.office.net/en-us/media/ee188ecd-f93d-4573-9b01-e11973de3e9a.png)
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
![Icon Community](https://support.content.office.net/en-us/media/f9cd8fac-e1df-4bd7-9f76-0098e0e77d7e.png)
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
![Icon feature request (light bulb, idea)](https://support.content.office.net/en-us/media/4c746d07-a10c-46f3-afe5-17a8f9628ccc.png)
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.
![Icon Experts (brain, gears)](https://support.content.office.net/en-us/media/ee188ecd-f93d-4573-9b01-e11973de3e9a.png)
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
![Icon Community](https://support.content.office.net/en-us/media/f9cd8fac-e1df-4bd7-9f76-0098e0e77d7e.png)
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
![Icon feature request (light bulb, idea)](https://support.content.office.net/en-us/media/4c746d07-a10c-46f3-afe5-17a8f9628ccc.png)
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.