Open a WRS from Excel with POV
I have some reports (WRS) that I want to open via excel, I can do with shared connections Reporting Settings.
In each tab I have a report (I have 20 tabs) and I would like when I open Excel prompt me POV to change it, because only appears when open report for the first time.
This is an example and you can see that is RF0309 and 2023 selected because when I opened this report I chose this scenario and is saved, now only can refresh data and refresh good, but I can't change scenario.
Is there a way to prompt this filters? via SmartView VBA functions or workaround.