Skip to Content
Former Member
Apr 11, 2012 at 01:40 PM

SBOP Analysis for Office with protected sheets



Is there a solution to use one sheet of a workbook with data coming from a query based on Analysis for office tool and the other sheets are calculated excel worksheet protected ?

because i can not apply a protection because the analysis tab can not be refresh. the problem is i need to deploy this workbook and i don't want that users changes Excel formulas on the other worksheet.

so is there a solution do to it ?

Thank you