Forum Discussion
Solved
Link to another excel file
Hi, In my excel file I want to create a hyperlink to another file, so that when the user clicks the link the other file will open in an new window and be filtered on parameters defined in the fir...
I believe that a suggested solution with Power Query would be possible, best suited.
My knowledge about Power Querry is limited, maybe one of the specialists here could contact you and suggest a solution, if possible.
Here are some links to help you a little further.
Connect to a SharePoint folder from Power Query Desktop
Combining Excel Files hosted on a SharePoint folder with Power BI
Get Data "From Folder" from Sharepoint Folder
Thank you for your understanding and patience
I wish you much success in your project
NikolinoDE
I know I don't know anything (Socrates)
Thanks, but my first step is actually to create the link. I have two files with some of the same columns. When I click a link in file 1, file 2 should open - but filtered on the lines defined by the data in file 1. How do I do that?
