Forum Discussion
Open excel sharepoint file from Power BI at a specific tab
Hi,
I have an excel file with multiple tabs saved on sharepoint.
In Power BI I have created a button with a link action that when pressed will open the excel file from sharepoint in excel.
Is there any way that I can get the link to open the excel file at a particular tab?
So that, for instance, if a user clicked a button called 'excel Tab A' it will open the excel file at Tab A or if they clicked a button called 'excel Tab B' it will open the excel file at Tab B etc? Don't want to import the data into Power BI at this point, just want the excel file to open on a particular tab so that users can add data into the excel file.
You can do this when accessing the web version of the file by adding
&activeCell=%27tabName%27!A1
to the end of the file URL. Obviously you need to change 'tabName' to the name of the tab you want opened.
2 Replies
You can do this when accessing the web version of the file by adding
&activeCell=%27tabName%27!A1
to the end of the file URL. Obviously you need to change 'tabName' to the name of the tab you want opened.
Ah, thank you muchly. I will try this tomorrow when I'm back in the office.
