Opening a Single Excel File in Different Custom Views Via Hyperlinks

[kent.carey]

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

 

[N10]

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

Hi

We run a similar set up to the one you are seeking.

Bascially we serve a shared single copy of a file from a server

User login in is via VBA splash screen

Dependant of the user login a sub routine is called as a form close event
which formats the sheet to the requirements of any given
approved user.

Hope this helps

Regards N10