Forum Discussion
Power Query locking when someone opens a separate referenced Pivot table file
I created a power query to import .csv files from a few folders and reformat them / merge data from other files etc. I created a sepearate Pivot table excel file that about 10 managers use to see th...
So I remade the files in sharepoint and copied a big chunk of the query code and that part is working now. But now I cant figure out how to have a seperate excel file that has pivot tables which point back to the original sharepoint excel file. I created them using the desktop version of excel. I made them in the master query file and then hit move or copy and moved them to a new sharepoint excel file but it seems like it is trying to reference a temporary folder on my C drive instead of the actual sharepoint xlsx file. when i try to refresh it. Any thoughts? Thanks again