Opening Excel 2007 to a specific worksheet from a file:// link
- by Ben M
Our internal website links to Excel files on a network-mapped drive. The links specify the filename and worksheet to open, in the following format (path and link information omitted):
ExcelFileName#'SheetName'!$A$1
This works fine with Excel 2003, but we're moving to Excel 2007, which won't even open the file if that extra information is present.
I haven't been able to find a definitive answer on whether this feature has been removed (or the syntax changed) in 2007. Any help will be highly appreciated!