Hi
I have a input excel file, with a power query connection to a external file.
I want to load this file, and fille some data into a new sheet - preserving my power query connection.
So I want to take my SAMPLE FILE.xlsx - (with my power query connection)
Add;:
AgreementVersion: A12345789
Customer: Hamder83
Save SAMPLE FILE.xlsx as A12345789.xlsx