Security settings for published excel reports in MOSS 2007

Question

Hello,

I'm new in the sharepoint world and I am lost trying to understand how it works. With all the diferents configurations, settings, trusted locations, centrals points admins, shared services, sites, my sites, admin sites, etc... I have no clue where to start in order to figure out how it works all together. MOSS 2007 is really really hard to understand. For sure I would need some guidance, tutorial explaining the basics of sharepoint like: what is a library, what is a site, what is a central point, a shared service, what is really required for a sharepoint site to work, etc... Any link with less than 1500 pages explaining the key sharepoint concepts would be greatly apreciated.


My scenario:
We have some SSAS 2008 cubes setup and running. Some key users will use Excel 2007 in order to analyze the data in the cubes.
For centralizing purposes the odc files required to connect to the cubes will be stored in a DataConnection library in a sharepoint site. And the key users will point to this odc in order to connect into the cubes.
We were thinking to let the key users save their xlsx files in sharepoint too, so other users would be able to read and visualize the key user excels within web explorer. Additionally the IT department would publish some xlsx files that should be protected for modifications.

From what I see until now, when you put a excel files in sharepoint, a user could:
"View excel in Web Explorer": I could see and do drilldown, but I cannot modify the file
"Open excel in client Excel": I could modify the excel in local and replace the server version.
"Open a snapshot in client Excel": just a snapshot,  no data connection, no drilldown, etc.

The question:
I have no idea how can I manage security in this scenario.
I would like to have:
-Some users that would be able to open some excels in client excel but they should not be able to modify the original excel in sharepoint.
-Some users that would not be able to open some excels in client excel but they should be able to view excel in web browser.
-Some users that would be able to create new excels, publish them into sharepoint and let other users consume the excel but not modify them.
-IT users could do whatever :). This one I think I could do it easily.

Where could I find the options in the sharepoint site (or any other place) for managing this security settings?

Thanks in advance

Answer 1

Hi Eduard

You can refer below articles & demo for better unerstanding:

Introduction to Excel Services and Excel Web Access
http://office.microsoft.com/en-us/sharepointserver/ha101054761033.aspx

Demo: Enable Excel Services and data connections for a SharePoint team site
http://office.microsoft.com/en-us/sharepointserver/HA102078901033.aspx

Excel Services Architecture

http://msdn.microsoft.com/en-us/library/ms582023.aspx

Using Excel Web Services in a SharePoint Web Part

http://msdn.microsoft.com/en-us/library/aa973804.aspx

Regards,
Yogesh.