I have used Pivot table referring to the power bi connection and set auto refresh when open the excel. Tick the check box 'Refresh data when opening the file'. Excel pivot table refresh vs refresh all VBA offers a solution how to automatically refresh pivot table every time you activate "pivot table" sheet, there are other ways to solve this as well like refreshing pivot table every time a cell in data source table is edited.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |