SOLVED
Home

Excel Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-352891%22%20slang%3D%22en-US%22%3EExcel%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352891%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20I%20have%20a%20question%20on%20Pivot%20Tables%20and%20Charts.%26nbsp%3B%20I%20want%20to%20know%20how%20to%20add%20new%20data%20to%20a%20Pivot%20Table%20when%20you%20have%20already%20completed%20a%20Pivot%20Table%20chart.%26nbsp%3B%20For%20instance%2C%20on%20the%20Pivot%20Table%20I%20used%20names%20of%20states%20and%20numbers%20of%20female%20to%20male%20doctor%20ratios%20within%20that%20state.%26nbsp%3B%20When%20I%20completed%20the%20clustered%20column%20chart%2C%20I%20later%20saw%20that%20I%20missed%20a%20state%20and%20its%20information.%26nbsp%3B%20When%20I%20tried%20to%20put%20the%20information%20in%20I%20was%20not%20able%20to.%26nbsp%3B%20How%20do%20I%20add%20the%20information%20without%20having%20to%20start%20all%20over%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-352891%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353410%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353410%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20for%20your%20help!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352893%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352893%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20order%20to%20add%20data%20to%20your%20pivottable%2C%20you%20need%20to%20add%20data%20to%20the%20original%20datatable.%20Probably%20tab%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679510%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679510%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20there%2C%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F286119%22%20target%3D%22_blank%22%3E%40robertpaegelow%3C%2FA%3E%3C%2FP%3E%3CP%3EWell%2C%20we%20can%20always%20add%20data%20to%20the%20source%20table%20and%20then%20refresh%20manually%20the%20pivot%20table%20or%20automacally%2C%20when%20opening%20the%20workbook.%20But..%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20update%20data%20in%20the%20pivot%20table%20really%20dynamically%2C%20that%20is%2C%20right%20after%20adding%20or%20changing%20data%20in%20the%20original%20source%20table%20(without%20having%20to%20manually%20refresh%20the%20pivot%20table%2C%20or%20automacally%2C%20opening%20again%20the%20workbook)%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3Eumbertojmf%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797246%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797246%22%20slang%3D%22en-US%22%3EYes%2C%20I%20want%20to%20add%20new%20data%2C%20but%20what%20do%20I%20do%20to%20get%20the%20Pivot%20Table%20to%20re-execute%20to%20include%20the%20new%20data%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797249%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797249%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357057%22%20target%3D%22_blank%22%3E%40umbertojmf%3C%2FA%3E%26nbsp%3B%26amp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F109928%22%20target%3D%22_blank%22%3E%40Mac%20Lingo%3C%2FA%3E%26nbsp%3BUnfortunately%20there%20is%20no%20built-in%20feature%20that%20does%20what%20you%20want%20(at%20least%20what%20i%20know%20of).%20I'm%20pretty%20sure%20that%20the%20only%20way%20to%20achieve%20the%20auto-update%20is%20by%20using%20a%20macro.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20found%20a%20pretty%20good%20guide%2C%20hope%20that%20this%20helps%20you%20in%20the%20right%20direction.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelcampus.com%2Fvba%2Frefresh-pivot-tables-automatically%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excelcampus.com%2Fvba%2Frefresh-pivot-tables-automatically%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Nikki_G2019
New Contributor

Hello all,

 

      I have a question on Pivot Tables and Charts.  I want to know how to add new data to a Pivot Table when you have already completed a Pivot Table chart.  For instance, on the Pivot Table I used names of states and numbers of female to male doctor ratios within that state.  When I completed the clustered column chart, I later saw that I missed a state and its information.  When I tried to put the information in I was not able to.  How do I add the information without having to start all over?

5 Replies
Solution

Hello!

 

In order to add data to your pivottable, you need to add data to the original datatable. Probably tab 1.

Thank you so much for your help!

Hi, there,@robertpaegelow

Well, we can always add data to the source table and then refresh manually the pivot table or automacally, when opening the workbook. But..

Is there a way to update data in the pivot table really dynamically, that is, right after adding or changing data in the original source table (without having to manually refresh the pivot table, or automacally, opening again the workbook)? 

Thanks in advance

umbertojmf

Yes, I want to add new data, but what do I do to get the Pivot Table to re-execute to include the new data?

@umbertojmf & @Mac Lingo Unfortunately there is no built-in feature that does what you want (at least what i know of). I'm pretty sure that the only way to achieve the auto-update is by using a macro. 

 

I've found a pretty good guide, hope that this helps you in the right direction.

https://www.excelcampus.com/vba/refresh-pivot-tables-automatically/

Related Conversations