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...
So this is still not solved. if the file is not the only or first Excel spreadsheet opened then the refresh fails. sometimes the fisrt open will work and sometimes it won't. appears to be no reason for it to fail other than other open instance of excel with Power Query in use.
Still frustrated by the lack of consistent funtionality of this seemingly hepful module.
Update,
Can definitely confirm that it is a collision of two open instance of excel configured to access the files in the same folder that causes the refresh to not work. Makes no sense.
Can anyone suggest why this might occur?