I have an excel workbook stored in Sharepoint 2010 document library. It contains several named sheets. I wwant to link to the workbook from a Wiki or List but I want specific sheets to be visible when workbook opened. I tried using following command which works fine away from Sharepoint:
where #NamedRange is jsut a range specified on each sheet so they can be identified. As said, this works fine on local hard drive but not within SP. Can it be done? If so please share solution.
We are using Sharepoint 2010 and Firefox 3.6.3