Thanks, especially for the error description and solution. Paul

Thanks Jeff, as always great info...

Good job Jeff 👍

No need to edit a query to change the data source. In Excel go to Data -> Get Data -> Data Source Settings... and change it there. Also to select all columns in Power Query, select one column and then hit [Ctrl]A.

That was a great video. Do you know if the excel has some formula using a change the color of the text or number? For example, if you use Xlookup formula, when you bring the text or number and, in this formula, use other formula to change the color. Thank you.

What about if the file location never changes but the file is replaced by a different named file, such as one indicating the date along with a name?