Power Pivot Quick Explorer feature not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2119132%22%20slang%3D%22en-US%22%3EPower%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119132%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20made%20a%20Power%20Pivot%20table%20and%20on%20my%20computer%20I%20can%20click%20on%20the%20table%20and%20the%20Y%20axis%20and%20an%20option%20called%20quick%20explore%20comes%20up.%20But%2C%20when%20I%20access%20this%20document%20from%20someone%20else's%20computer%20they%20don't%20have%20this%20quick%20explore%20feature.%20Very%20useful%20feature%20and%20I%20would%20like%20other%20users%20to%20have%20the%20same%20access.%20Any%20idea%20why%20the%20quick%20explore%20feature%20won't%20work%20on%20another%20computer%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2119132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121620%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121620%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20believe%20we%20all%20have%20E3%2C%20and%20I%20added%20the%20add%20in%20for%20the%20pivot%20chart%20on%20their%20computer%20as%20well.%20No%20differences%20between%20our%20programs%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121615%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960948%22%20target%3D%22_blank%22%3E%40JPapa98%3C%2FA%3E%26nbsp%3BSame%20subscription%20(Business%20Premium%2C%20E3%2C%20etc)%3F%20Some%20of%20them%20have%20limited%20functionality.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121604%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121604%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwhen%20I%20look%20it%20up%20we%20all%20use%20Microsoft%20Excel%20for%20Microsoft%20365%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120987%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960948%22%20target%3D%22_blank%22%3E%40JPapa98%3C%2FA%3E%26nbsp%3BThat's%20not%20necessary%20the%20same.%202016%20could%20be%20Pro%2C%20could%20be%20Student%2C%20whatever.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120983%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYes%2C%20all%20are%20either%202013%20or%202016%20excel.%20Mine%20is%2016.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120962%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120962%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960948%22%20target%3D%22_blank%22%3E%40JPapa98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20Excel%20on%20other%20machines%20is%20exactly%20the%20same%20as%20yours%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120123%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BFiles%20are%20in%20the%20exact%20same%20location%20on%20a%20shared%20drive.%20Not%20sure%20why%20no%20one%20else%20can%20use%20quick%20explore.%20I've%20tried%20everything%20I%20can%20find%20but%20still%20nothing.%20Very%20strange%2C%20wish%20I%20could%20figure%20it%20out.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119519%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119519%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960948%22%20target%3D%22_blank%22%3E%40JPapa98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20see%2C%20thank%20you.%20Quick%20Explore%20is%20available%20starting%20from%20Excel%202013%20as%20I%20remember%2C%20only%20interface%20was%20changing%20a%20bit.%20If%20you%20don't%20see%20it%20on%20exactly%20the%20same%20file%20on%20another%20computer%20with%20Excel%20which%20supports%20data%20model%20-%20that's%20strange.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20files%20are%20different%20-%20maybe.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119503%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119503%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYes%20you%20could%20refer%20to%20it%20as%20PivotChart%20and%20PivotTable.%20But%20I%20meant%20quick%20explore.%20I've%20attached%20a%20screenshot%20of%20what%20I'm%20talking%20about.%20Quick%20explore%20comes%20up%20when%20I%20hover%20over%20data%2C%20or%20right%20click%20on%20it.%20But%20it%20doesn't%20show%20up%20on%20other%20computers.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JPapa98_0-1612905122966.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253717i413BF9372FE39221%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JPapa98_0-1612905122966.png%22%20alt%3D%22JPapa98_0-1612905122966.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119489%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Quick%20Explorer%20feature%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119489%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960948%22%20target%3D%22_blank%22%3E%40JPapa98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20I%20missed.%20Perhaps%20you%20mean%20PivotChart%20or%20PivotTable%2C%20not%20Power%20Pivot%3F%20And%20maybe%20Quicks%20Analysis%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I've made a Power Pivot table and on my computer I can click on the table and the Y axis and an option called quick explore comes up. But, when I access this document from someone else's computer they don't have this quick explore feature. Very useful feature and I would like other users to have the same access. Any idea why the quick explore feature won't work on another computer?

10 Replies

@JPapa98 

Sorry, I missed. Perhaps you mean PivotChart or PivotTable, not Power Pivot? And maybe Quicks Analysis?

@Sergei Baklan Yes you could refer to it as PivotChart and PivotTable. But I meant quick explore. I've attached a screenshot of what I'm talking about. Quick explore comes up when I hover over data, or right click on it. But it doesn't show up on other computers. 

JPapa98_0-1612905122966.png

 

@JPapa98 

I see, thank you. Quick Explore is available starting from Excel 2013 as I remember, only interface was changing a bit. If you don't see it on exactly the same file on another computer with Excel which supports data model - that's strange.

 

If files are different - maybe.

@Sergei Baklan Files are in the exact same location on a shared drive. Not sure why no one else can use quick explore. I've tried everything I can find but still nothing. Very strange, wish I could figure it out. 

@JPapa98 

And Excel on other machines is exactly the same as yours?

@Sergei Baklan Yes, all are either 2013 or 2016 excel. Mine is 16. 

@JPapa98 That's not necessary the same. 2016 could be Pro, could be Student, whatever.

@Sergei Baklan when I look it up we all use Microsoft Excel for Microsoft 365

@JPapa98 Same subscription (Business Premium, E3, etc)? Some of them have limited functionality.

@Sergei Baklan I believe we all have E3, and I added the add in for the pivot chart on their computer as well. No differences between our programs