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? |
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