Excel 365 Analyze Data and Protected Worksheets

Copper Contributor



Is there a way to use the Excel 365 Analyze Data (formerly Ideas) when your worksheet is protected?  I have tried various different protection flags and it seems that Analyze Data becomes greyed out once protection is turned on regardless of the settings.


I think the answers Analyze gives would be useful even if you cannot insert the pivot tables it creates or if it inserted them onto a non-protected worksheet.


Thanks for any insights.



1 Reply
I subscribed in office 365 and analyze data bar is not on home instead I have idea icon