How to Automatically open a specific cell from MS Sharepoint?

bujago

New Member
Joined
Jun 11, 2014
Messages
1
I’ve made an Excel with 2 sheets. Let’s say sheet “A” and sheet “B”.

I’m in sheet “A” and when a user clicks on a specific cell I want to be able to navigate to another specific cell in sheet “B”.

I’ve made this using hyperlinks and “Place in This document option” from Excel

It worked fine.

Although I now want to be able to automatically open the specific cell in the sheet “B” above mentioned, from my intranet page in MS Sharepoint 2007. I’ve tried the HTML editor but it only opens the excel file from the last saved position!

Is there a way to find the destination link from the specific cell from sheet “B”?

Are there any alternatives to do that?

Thanks
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,215,575
Messages
6,125,618
Members
449,238
Latest member
wcbyers

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