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
