Excel for the web may not show the Insert PivotTable button in the ribbon

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.

Excel Tech Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Provide feedback

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Provide feedback

See Also

Fixes or workarounds for recent issues in Excel for PC

Fixes or workarounds for recent issues in Excel for Mac