Open excel sharepoint file from Power BI at a specific tab

[Fusilier]

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.

[jgeddes · Accepted solution]

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.

[Fusilier]

Ah, thank you muchly. I will try this tomorrow when I'm back in the office.