Sep 17 2021 07:18 AM
We recently transitioned to M365. I am creating pivot tables in M365 to share with others in the company. When they open the file, they are unable to double click the value to get to the data. How do I create a pivot that is linked where they can easily access that data?
Thank you in advance!
Kjanvrin
Sep 17 2021 10:41 AM
Source data is in the same file?
Sep 17 2021 10:47 AM
Yes. I copied the source data into the file and created the pivot in M365.
Sep 17 2021 02:52 PM
SolutionIf that's Excel for web, drill-down is not supported for it. Or you mean desktop version?
Sep 20 2021 06:46 AM
Sep 17 2021 02:52 PM
SolutionIf that's Excel for web, drill-down is not supported for it. Or you mean desktop version?