I have two tables in Excel 2016 powerpivot.
One is coming from an access database and has 500,000+ rows, [Invoices].
The second is a linked table within the excel document, [New_Prices].
The idea is to enter in new pricing in the linked table, and refresh the pivot table so that it reflects the new prices.
But when I right click the pivot table to refresh, it refreshes both the [New_Prices] table and the [Invoices] table which makes it unnecessarily long as I don't need the [Invoice] table updated.
Is there a way to update the model in powerpivot without having to open it and manually selecting the table i want refreshed?
I was thinking of a VBA macro, but I dont know how to specify a table in powerpivot.
One is coming from an access database and has 500,000+ rows, [Invoices].
The second is a linked table within the excel document, [New_Prices].
The idea is to enter in new pricing in the linked table, and refresh the pivot table so that it reflects the new prices.
But when I right click the pivot table to refresh, it refreshes both the [New_Prices] table and the [Invoices] table which makes it unnecessarily long as I don't need the [Invoice] table updated.
Is there a way to update the model in powerpivot without having to open it and manually selecting the table i want refreshed?
I was thinking of a VBA macro, but I dont know how to specify a table in powerpivot.
