I am trying to do something I am not sure is possible. I have a large
Excel file being used as a database. Multiple users are interested in
accessing this data, but they would prefer to have the spreadsheet
open in the custom view that selects the data of most interest to
them. As the group who maintains the spreadsheet database, we would
prefer to use a single Excel spreadsheet, but have each hyperlink from
our webpage customized to open the spreadsheet in a specified custom
view. For example, if the spreadsheet contains list of projects with
all universities, we would like one hyperlink to open the spreadsheet
with a custom view that filters for University A and another to open
the same spreadsheet with a custom view set for University B. Is this
possible without saving separate copies of the spreadsheet for each
view?

Thanks in advance for any hints you might be able to give me.

Best regards,

Kent

Kent,
I don't know of a way to specify a View from a hyperlink, but you set a
named range:

<PathToFile\File.xls#RangeName

NickHK

wrote in message
oups.com...
I am trying to do something I am not sure is possible. I have a large
Excel file being used as a database. Multiple users are interested in
accessing this data, but they would prefer to have the spreadsheet
open in the custom view that selects the data of most interest to
them. As the group who maintains the spreadsheet database, we would
prefer to use a single Excel spreadsheet, but have each hyperlink from
our webpage customized to open the spreadsheet in a specified custom
view. For example, if the spreadsheet contains list of projects with
all universities, we would like one hyperlink to open the spreadsheet
with a custom view that filters for University A and another to open
the same spreadsheet with a custom view set for University B. Is this
possible without saving separate copies of the spreadsheet for each
view?

Thanks in advance for any hints you might be able to give me.

Best regards,

Kent