2584976 - The functionalities of components tab are disabled when workbook or worksheet is protected.

Below functionalities of components tab are disabled when workbook or worksheet is protected.

• Refresh Workbook on Opening
• Force Prompt for Initial Refresh
• Subsequent Refresh
• Store Prompts with Workbook
• Remove Data Before Saving
• Merge Variables 

SAP Analysis for Microsoft Office

Protect a workbook or worksheet.

This is standard design of Analysis for Office. And there is no way to enable functionalities of components when workbook or worksheet is protected.

If you want use these functionalities, you can unprotect workbook or worksheet and then select the expected functionalities.

You can check user guide of Analysis for Office about how to protect or unprotect a workbook or worksheet.

greyed out, grey out, impossible, loose possibility, Protection, work book, work sheet, adjust, adjustable, change, settings, option, password, behaviour, Analysis for Excel, Analysis for office, AO, AFO , KBA , BI-RA-AO-XLA , Excel Addin , Product Enhancement