Feb 09 2021 07:38 AM - edited Feb 09 2021 07:40 AM
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?
Feb 09 2021 12:59 PM
Sorry, I missed. Perhaps you mean PivotChart or PivotTable, not Power Pivot? And maybe Quicks Analysis?
Feb 09 2021 01:13 PM
@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.
Feb 09 2021 01:27 PM
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.
Feb 10 2021 05:00 AM
@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.
Feb 10 2021 12:44 PM
And Excel on other machines is exactly the same as yours?
Feb 10 2021 01:03 PM
@Sergei Baklan Yes, all are either 2013 or 2016 excel. Mine is 16.
Feb 10 2021 01:13 PM
@JPapa98 That's not necessary the same. 2016 could be Pro, could be Student, whatever.
Feb 11 2021 05:05 AM
@Sergei Baklan when I look it up we all use Microsoft Excel for Microsoft 365
Feb 11 2021 05:19 AM
@JPapa98 Same subscription (Business Premium, E3, etc)? Some of them have limited functionality.
Feb 11 2021 05:23 AM
@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