While working on my Excel workbook I have discovered that a csv file I use in queries is not saved when I try to overwrite it via an export from 3rd party software. It appears that the csv file is in use and cannot be overwritten. I have verified the file is not updated by checking the date/time of the file. Windows 10 does not give me any warning when the file is not saved correctly. When I go to the location of the file and try to delete it, I get an error message that it is in use by "microsoft.mashup.container.loader.exe". I have to close Excel then export the csv file from the 3rd party software (overwriting the old) then relaunch excel and continue my work. This is an ok workaround but sometimes I fail to catch that the file was not overwritten with the new export. Anyone have a solution? Not much coming up in an internet search. Thanks
Bookmarks