Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

Award-winning PDF software

review-platform review-platform review-platform review-platform review-platform

Video instructions and help with filling out and completing Fill Form 8815 Reload

Instructions and Help about Fill Form 8815 Reload

Welcome to Excel campus. My name is John, and in this video, I'm going to explain how to automatically update your pivot tables when the source data changes. So, here we have a simple pivot table. On this data sheet, we have the source data for the pivot table. Anytime we make a change to this source data range, whether we edit a cell or copy and paste new data below the table, we want our pivot table to automatically update. To achieve this, we're going to use a simple macro, and I'll explain how that works. The first thing you'll want to do is save your workbook as a macro-enabled workbook. You can see I have this workbook as a .xlsm extension. If you're not familiar with that, I have a whole another video series that explains how to get started with macros in VBA and create macro-enabled workbooks. I'll put a link to that in the description below this video. So, we're going to open the VBA editor. You can do this by clicking on the Developer tab, then the Visual Basic button. You can also use the keyboard shortcut Alt+F11. Within the VBA editor, on the left side and the Project Explorer window, you want to find the workbook that contains the pivot tables. Within that workbook, find the sheet object that contains the source data. Here, within the Microsoft Excel objects folder, you might need to expand it to find our sheet, the data sheet that contains the source data. Double-click on that to open the code module for that sheet object. Within the code module, we're going to add our macro. To add an event, click the dropdown and choose "Worksheet". This will add the Worksheet Selection Change event, which we don't need. We want to select the Change event...