Excel 365 Analyze Data and Protected Worksheets

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