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