Updating pivot tables in excel 2016

Start your free month on Linked In Learning, which now features 100% of courses.

updating pivot tables in excel 2016-5updating pivot tables in excel 2016-59updating pivot tables in excel 2016-10

This course shows how to build Pivot Tables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable.

Plus, learn how to create Pivot Charts to visualize your data, enhance Pivot Tables with macros, and use the Data Model feature to build Pivot Tables from related tables.

I have used this particular pivot table (shared with other users in the office) for several years, and never had an issue updating the Pivot Table Data Source table/range. I've changed the name of the table to the generic "Tablename", and I'm simply trying to change the ending row from 2525 to 2543.

Each time I update the source data on the pop-up, Tablename!

Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access.