create a dynamic hyperlink to a excel online workbook specific sheet

promoboy

New Member
Joined
Dec 5, 2010
Messages
19
Is it possible to create a clickable link to excel online to go to a specific sheet?
i have the good hyperlink to go to the document but not to go to the specific sheet
the working link to the document is:
Excel Formula:
=hyperlink("https://somesite.sharepoint.com/:x:/r/sites/Sharepointname/Shared%20Documents/Planning/2023/Planning_Week%2012.xlsm?&web=1", "Link")
this opens the workbook online even when it is clicked in desktop application

someone can help me?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Don't know from your description if this will work for you but you could put a workbook open event into the workbook so that when user opens the file they are taken to the respective sheet. The workbook must be macro enabled (.xlsm file). This takes user to Sheet1 when the workbook is opened. Hopefully you know about events?

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub
 
Upvote 0
Don't know from your description if this will work for you but you could put a workbook open event into the workbook so that when user opens the file they are taken to the respective sheet. The workbook must be macro enabled (.xlsm file). This takes user to Sheet1 when the workbook is opened. Hopefully you know about events?

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub
Jim,
Thanks for your reaction.

It's not possible in vba because the workbook runs in the excel online environment and it need to be dynamic.
I have a dashboard with button for all days of the month.
Every week is a other workbook and every day is a sheet in those workbooks.
So when people press on a specific day, that workbook should open on that specific day (sheet) all in online excel without vba.
So i was thinking doing it with a hyperlink formula, only the hyperlink does work in excel dektop app but not online.
this is my formula that works in excel desktop but not online:
Excel Formula:
https://somesite.sharepoint.com/sites/mysharepoint/Shared%20Documents/FOLDER/2023/Planning_Week 8.xlsm#maandag!
this opens the workbook online but need to adjust that to the sheet:
Excel Formula:
https://somesite.sharepoint.com/:x:/r/sites/mysharepoint/Shared%20Documents/folder/2023/Planning_Week%208.xlsm?&web=1
 
Upvote 0

Forum statistics

Threads
1,224,883
Messages
6,181,551
Members
453,052
Latest member
ezzat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top