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
Bookmarks