ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   External data refresh (https://www.excelbanter.com/excel-discussion-misc-queries/138616-external-data-refresh.html)

Texas Tonie[_2_]

External data refresh
 
Upon hitting 'refresh all', my data page refreshes all-right, but my
connected pivot table does not. If I hit 'refresh all' again, it does.

Is there a way that I can refresh the data page, and have it also refresh
the pivot table in a single go?



challa prabhu

External data refresh
 
Hi,

No.

Connected Excel sheet have different Data column. Therefore, depending upon
the number of excel sheet you have incorporated in your Excel sheet, you have
to refresh those number of times. Because they are different data source
definition.

Challa Prabhu

"Texas Tonie" wrote:

Upon hitting 'refresh all', my data page refreshes all-right, but my
connected pivot table does not. If I hit 'refresh all' again, it does.

Is there a way that I can refresh the data page, and have it also refresh
the pivot table in a single go?




All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com