Dear all,
I'm very new to this forum and already found a few useful tips !
But I'm now stuck with an issue :

I have multiple pivot table connecting to an external data source, and I would need to set the filter value thanks to another cell (entered manually for example) in the sheet.

Unfortunately, I cannot use any code for this purpose as the excel file will be published as a webpart on a sharepoint site, and VBA/macros are not supported.

I have been through many excel parameters I could find, but didn't manage to find a way to do it. It would be so great if one of you had a solution or a turnaround in mind !

Many thanks