Since we only want the code to run when the user edits/changes cells, we use the Change event. Note: The SelectionChange event that is added by default will run any time the user selects a cell in the sheet. We can add VBA code to the Worksheet_Change event to perform actions when the user edits cells. The Worksheet_Change event macro will run any time a change is made to cells in that worksheet.

Now we will highlight and delete the unnecessary code below it. This adds a new event at the top called Worksheet_Change.

Before we do, let’s go to the Procedure drop-down menu on the right and choose Change. That will add a Worksheet_SelectionChange event to the module, which we don’t actually want, so we will delete it in just a moment. To do so, choose Worksheet in the Object drop-down box on the left. Within the code module, we want to create an event macro. Add a new event for worksheet changes.ĭouble-clicking on the sheet opens up the code module for that object. If you don’t see the Project Explorer window you can enable it from the View menu (keyboard shortcut: Ctrl+ R). Select the sheet that contains the source data. Under that workbook are listed the sheets within the workbook. In the Project Explorer window of the Visual Basic editor, locate the workbook that you want to change. Open the Sheet Module that contains your source data. You only have to do this once, and then the Developer tab will always be visible every time you open Excel in the future. If you don’t see the Developer tab, you can make it visible using the instructions here. The keyboard shortcut for opening the Visual Basic editor is Alt+ F11. You can do this by clicking the Visual Basic button on the Developer tab of the ribbon. That instruction basically says: when I make a change to my worksheet, refresh all the pivot tables and data connections. To automatically update our pivot tables, we are going to write a macro with one simple instruction. Watch the first video in that series on Pivot Tables & Dashboards

If you’re not too familiar with macros and VBA, I suggest checking out my free 3-part video series on getting started with Macros & VBA.Īlso, if you are new to pivot tables, I have a series to walk you through what they are and how to use them. It requires the use of a really simple macro that I will show you how to create below. Refresh-Pivot-Table-Automatically.zip Download Update Pivot Tables AutomaticallyĬan your pivot tables be updated immediately and automatically when their source data changes?Ībsolutely.

How to download visual basic for excel