Pivot table functionality in M365

New Contributor

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

4 Replies

@Kjanvrin 

Source data is in the same file?

@Sergei Baklan 

Yes.  I copied the source data into the file and created the pivot in M365.

@Kjanvrin 

If that's Excel for web, drill-down is not supported for it. Or you mean desktop version?

I was really afraid of that. We are using the web version.

Thank you for your answer!