Is there a way to have both manual data entry and keep the excel query updating when new files are added to the source
I have a excel power query table listing all the files in a folder and i want to have both a column for manual data entry and have it automatically update. I have created the column for manual data entry according to the video down below and that works but now it doesnt update when new files are added to the source folder