Updating data in pivot table
Create _ (Source Type:=xl Database, Source Data:="Data2") Next pt End Sub Assuming you're willing to use VBA, this might be relevant. Worksheets("Sheet1") ' Dynamically Retrieve Range Address of Data Set start Point = data Sheet. All you have to do is just create a pivot table with your source data and after that change the source with the named range using the same method which I have used in the first method of tables. Create(Source Type:=xl Database, Source Data:=New Range) 'Ensure Pivot Table is Refreshed Pivot_Sheet.
I making a small app for internal orders at a restaurant and need to update the quantity on a pivot table after an order is made.If you use pivot tables in your work frequently, I am sure you face the problem to update its source data range manually.Every time when you add new data in the source sheet you need to update the source range for the pivot table before you refresh your pivot table.But i have many products for one order so i need to update all of the products their cantidad.Is there an easy way to update the data source for multiple pivot tables on a single Excel sheet at the same time? If you iterate through the Pivot Table collection on each sheet, you should be able to use the method shown in that post to amend the data source.