right click on the pivot table in excel choose wizard click 'back' click 'get data' in the query window File Table Definition. then you can create a new or choose a different connection. worked perfectly. the get data button is next to the tiny button with a red arrow next to the range text input box.How can the answer be improved? change source data in pivot table excel
Dec 28, 2016 If all of your Pivot tables have been created to reuse the same data source, then they all use the same PivotCache which is the data all of your pivot tables are based on. That means you can make one SourceData change and have all the Pivot tables update.
MS Excel 2010: How to Change Data Source for a Pivot Table. Answer: Select the Options tab from the toolbar at the top of the screen. In the Data group, click on Change Data Source button. When the Change PivotTable Data Source window appears, change the TableRange value to reflect the new data source for your pivot table. Click on the OK button. Change Data Source One Pivot Table. Follow these steps, to change the data source for a single pivot table. Select a cell in the pivot table that you want to change. On the Ribbon, under PivotTable Tools, click the Options tab. Click the upper part of the Change Data Source command. change source data in pivot table excel To change the data source of a PivotTable to a different Excel table or a cell range, click Select a table or range, and then enter the first cell in the TableRange text box, and click OK. To use a different connection, do the following: Click select a Use an external data source
To change the source data for an Excel pivot table, follow these steps: Select any cell in the pivot table. On the Ribbon, under the PivotTable Tools tab, click the Analyze tab (in Excel 2010, click the Options tab). In the Data group, click the top section of the Change Data Source command. change source data in pivot table excel Dec 07, 2017 I have a file with around 150 pivot tables pointing to 2 different excel data source files placed on a server. Due to lack of available space, I've moved both data source to another place but the path on each pivot table has not changed (AnalyzeChange Pivot Table Data Source). Click anywhere into your Pivot Table so that the two Pivot Table ribbons Analyze and Design are shown. Go to the Analyze ribbon. Click on Change Data Source in the middle of the Analyze ribbon. Now you can see and change the source of your Pivot Table. You can also see, Aug 28, 2018 Pivot Table& Source Data on Same Sheet. Aleksandrs asked a great question on the YouTube video comments. If your pivot table and source data are on the same sheet then you will need to add code to disable events. The refresh puts the event in a recursive loop, and can end up crashing Excel. Here is the code to prevent that. Steps to Change the Data Source of a Pivot Table. Select any cell in the pivot table to reveal more pivot table options in the toolbar. In this example, we have selected cell A1 on Sheet2. You now should see 2 new tabs appear in the toolbar called Analyze and Design. Select the Analyze tab from the toolbar at the top of the screen.Rating: 4.87 / Views: 617