Excel 365 Analyze Data and Protected Worksheets

New Contributor

Hello.

 

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.

 

Alan

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