Forum Discussion

Copper Contributor

Dec 16, 2021

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...

excel

Formulas and Functions

NikolinoDE
Dec 20, 2021
AnneRdk
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)

AnneRdk

Copper Contributor

Dec 20, 2021

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?

NikolinoDE

Platinum Contributor

Dec 20, 2021

AnneRdk

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