In my spreadsheet I have a pivot table which looks up aroud 500 rows of data and that is filtered on a few defined account numbers.I am refreshing the source data daily, and every day I find myself checking that the pivot is still filtering on the correct accounts.If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. Hi guys, I'm having a weird issue with my beloved pivot tables.
You won’t be able to create new slicers in Excel Online.
I have about 10 pivot filters in the columns A&B that need to be selected and reapplied everytime a new user wants to apply a new filterset.
I need a macro that resets them back to "ALL" or "Multiple Selections" setting.
Go back to pivot table and select different filter, rinse and repeat for 168 critiera (portfolios) I currently have macros for all the steps in this process except selecting the pivot table filter critiera. I download the data from an sql server and then have to run a text to columns operation so that the date is in the correct format and an can be sorted.
I only need to select the filter critiera one at a time (no multiple values). When I built the pivot table from scratch, when I chose to filter by 'Creation date' there was no issue and I could select data from this year, last month, this week-no problem.
I would like to auto refresh both pivot tables by clicking on the worksheet tab.