Thanks, especially for the error description and solution. Paul
@BigD632 ай бұрын
Thanks Jeff, as always great info...
@ajayshivpuje37972 ай бұрын
Good job Jeff 👍
@jerrydellasala76432 ай бұрын
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.
@gonzuic2 ай бұрын
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.
@2bczar4u2 ай бұрын
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?