Forum Discussion
Power Query to Excel Table will not consistently refresh
Have several worksheets using power query to refresh data from a .csv file in a share on the same subnet as the workstation. Issue is that I can close all spreadsheets and reopen the one I want...
This simply will not work until i close and re open all instances of Excel. That is a software short fall. Not sure what the solotion is.
Follow up to this, I would be curious to find out how many users are not getting updated data because they don't know that this is occurring?