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
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.