Forum Discussion
Refresh Pivot Table while keeping the external source data open
Hi Amanda1901
I assume that you have created the pivot table from a Power Query, which reads that data from the external file, right?
In this case, I guess there is no way to avoid that error message, because Power Query will always complain if an external source file is open.
What you could do instead - if this is possible at all in your case - is to create the Pivot table directly in the external file (just for demonstration purposes) and then open a new window within this external file (Menu "View | New Window"). This way you can show the Pivot table in one window in your Teams session, while changing the source table in the other window.
I do not know if this is feasible in your case, but this is the only option I can think of.
I cannot thank you enough for your suggestion. I am not using power query; however, your suggestion was on point. I am able to have the pivot table in one instance/window and the data source in another one. More importantly when I make a change in the data source all I have to do is click refresh all in the pivot table and it automatically updates the pivot table without requiring to close the data source.
Thank you again!!!