Forum Discussion
Create an external URL link so my excel workbook opens on a specific sheet.
Hi, I have a Wiki site which currently uses URLS from individual excel sharepoint files for individuals on my team to open a workbook to record data. I am condensing these 10 files into one b...
Tested mate, does not work.
Thanks, LeonPavesic . After a bit of messing about (had to open my workbook in Web version of Excel to get the 'Link' option on the tab as it doesn't appear when I open it on desktop Excel). I'm trying to hyperlink to the workbook tab from a presentation to save copying the contents into the presentation itself (around 30 rows of data, for which it's complicated as these are dynamically updated, so copying data into a presentation risks being out of sync with the live data).
The absolute perfect solution would be to get the link to automatically open the workbook in Excel desktop but what you've offered is 90% of the way there - thank you!