Opening Excel 2007 to a specific worksheet from a file:// link

Posted by Ben M on Super User See other posts from Super User or by Ben M
Published on 2010-01-11T18:00:31Z Indexed on 2012/06/03 10:43 UTC
Read the original article Hit count: 221

Filed under:
|

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!

© Super User or respective owner

Related posts about excel-2007

Related posts about links