<div>
Are all the pivot tables pointed to the same source?<br />
<br />
Will different pivot tables having different most current dates?<br />
<br />
How you executed your scripts? By a button or when the workbook is opened?<br />
<br />
Do you have a sample to upload for us?
</div>


Are all the pivot tables pointed to the same source?

Will different pivot tables having different most current dates?

How you executed your scripts? By a button or when the workbook is opened?

Do you have a sample to upload for us?

<div>
In the data source create a column with a formula that determines whether the data for a particular row is Current or Previous.<br />
<br />
In the Pivot Table then filter on Current rather than Date. When the Pivots refresh they will change to valid filter already.
</div>


In the data source create a column with a formula that determines whether the data for a particular row is Current or Previous.

In the Pivot Table then filter on Current rather than Date. When the Pivots refresh they will change to valid filter already.

<div>
Attached is a sample of the spreadsheet. &nbsp;All tables are pointed to the same source. &nbsp;They will all need to have the same date. &nbsp;The script is manually executed.<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/06_w26/920033/SampleClass.xlsm" target="_blank" class="file-inline" title="SampleClass.xlsm (458 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SampleClass.xlsm</a>
</div>


Attached is a sample of the spreadsheet.  All tables are pointed to the same source.  They will all need to have the same date.  The script is manually executed.
SampleClass.xlsm [https://filedb.experts-exchange.com/incoming/2015/06_w26/920033/SampleClass.xlsm]

SampleClass.xlsm

SampleClass-b.xlsm

<div>
This worked perfectly! &nbsp;Thank you very much!
</div>


This worked perfectly!  Thank you very much!

<div>
<div class="content wysiwyg-content">
I have a spreadsheet with multiple pivot tables on multiple sheets. &nbsp;Each Monday additional information is added to the data behind the pivot table. &nbsp;I have created a script that will refresh all of the pivot tables, but I would also like for the script to update the filter value on all pivot tables to the most current date.<br />
<br />
Thank you in advance for any help you can provide.
</div>
</div>


I have a spreadsheet with multiple pivot tables on multiple sheets.  Each Monday additional information is added to the data behind the pivot table.  I have created a script that will refresh all of the pivot tables, but I would also like for the script to update the filter value on all pivot tables to the most current date.

Thank you in advance for any help you can provide.

Setting the filter value of all pivot tables

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.