I have created an excel template to use to create a pivot table. I basically just refresh the data when I create the spreadsheet. everything works fine except the report filter drop downs are empty and I can't seem to get them to refresh, even using excel.
Any ideas,
Scott C