Altering Pivot Chart Filters on a Protected Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-331702%22%20slang%3D%22en-US%22%3EAltering%20Pivot%20Chart%20Filters%20on%20a%20Protected%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331702%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20some%20help%20with%20this%20situation%3A%20I%20have%20a%20worksheet%20with%20many%20pivot%20tables%2C%20linked%20to%20a%20power%20pivot%20database.%20This%20worksheet%20is%20hidden.%3C%2FP%3E%3CP%3EI%20have%20a%20second%20worksheet%2C%20where%20I%20created%20some%20pivot%20charts%20(linked%20to%20the%20pivot%20tables%20from%20the%20hidden%20worksheet).%20The%20result%20was%20a%20very%20interesting%20dashboard%20from%20the%20visual%20perspective.%3C%2FP%3E%3CP%3ENow%20I%20need%20to%20protect%20this%20worksheet%20with%20the%20pivot%20charts%2C%20to%20prevent%20the%20users%20to%20move%20or%20delete%20the%20charts.%20What%20happens%20is%3A%20the%20filters%20on%20the%20pivot%20charts%20stop%20working.%20I%20know%20it%20is%20possible%20to%20make%20filters%20on%20a%20pivot%20table%20to%20keep%20working%20on%20a%20protected%20sheet%20(by%20selecting%20the%20%22Use%20Pivot%20Tables%20%26amp%3B%20Pivot%20Charts%22%20option%20when%20protecting)%2C%20but%20it%20seems%20that%20it%20doesn%C2%B4t%20work%20on%20pivot%20charts.%3C%2FP%3E%3CP%3EAnyone%20have%20any%20idea%20to%20make%20it%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-331702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

I need some help with this situation: I have a worksheet with many pivot tables, linked to a power pivot database. This worksheet is hidden.

I have a second worksheet, where I created some pivot charts (linked to the pivot tables from the hidden worksheet). The result was a very interesting dashboard from the visual perspective.

Now I need to protect this worksheet with the pivot charts, to prevent the users to move or delete the charts. What happens is: the filters on the pivot charts stop working. I know it is possible to make filters on a pivot table to keep working on a protected sheet (by selecting the "Use Pivot Tables & Pivot Charts" option when protecting), but it seems that it doesn´t work on pivot charts.

Anyone have any idea to make it work?

 

0 Replies