<div>
That worked, thank you.<br />
<br />
Sandra
</div>


<div>
<div class="content wysiwyg-content">
I have a worksheet that contains a pivotable where the users can select one or more year to view. &nbsp;However, there is some automatica analsysi that needs to run when the year changes, but am not sure how to tell that when cell D12 (where the year filter is located) changes, run the FTEAnalysis code. &nbsp;On do not want it t run when anything else changes on the worksheet.<br />
<br />
Sandra
</div>
</div>


I have a worksheet that contains a pivotable where the users can select one or more year to view.  However, there is some automatica analsysi that needs to run when the year changes, but am not sure how to tell that when cell D12 (where the year filter is located) changes, run the FTEAnalysis code.  On do not want it t run when anything else changes on the worksheet.

Sandra

Run come when value of a PivotTable flter changes

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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