Excel Services Secuirty Issue

Excel Services Secuirty Issue

• newyuppie

  Hi John,

  Thanks so much. It's the minor versioning issue. Thanks the information.

  
  
  

• TimMakins

  The problem you are having is likely because of major/minor versioning settings. What is probably happening is that only a minor (or draft) version of the file is saved to the server. By default, only users with edit permissions can see it.

  I don't recommend granting lots of users edit permissions. The entire point of permission levels like View Only or Read is to allow users to view and interact with the file without compromising security on the file. A more secure solution is to either:

  • publish a major version of the file. This will be the one that everyone sees. When you want to make changes to the file, you will be changing the minor version. Once the file looks the way you want, just publish another major version. The trick here is to remeber to always publish a major version. Also note that new files saved to the doc lib will be saved as minor versions.
  • You can change the versioning settings in the doc lib settings pages, under versioning settings. Change the Draft Item Security setting such that users with Read permissions can view draft versions of files.

  
  

• KrisF

  Paul,

  What about users that are member of the built in roles e.g. Contributer, Reader can they render the document

  Is the document you're trying to render checked in and approved

  Can the user having the rendering issue, see it listed in the document library

  How did you configure the trusted location that contains the workbook for the provider did you select SharePoint

  
  

• Penny111

  Hi,

  User group with the following permission cannot render the document.

  	Read - Can view only.
  	Restricted Read - Can view pages and documents, but cannot view historical versions or review user rights information.
  	View Only - Members of this group can view pages, list items, and documents. If the document has a server-side file handler available, they can only view the document using the server-side file handler.

  (You can try this out in the Reports - Sample Dashboard page generated by MOSS)

  The document is checked in and no approval process is involved. The user cannot see the source document in the doc. lib.

  
  
  

• RyanB88

  Interesting... did you ever change the permissions on the doc lib or the file

  Try navigating to the doc lib, clicking on the file drop down and Edit Permissions.

  Make sure the groups you're having trouble with are listed, if not, add them and try navigating under those permissions again.

  PS: The earlier question about the UNC vs Doc Lib was just for our troubleshooting purposes, they use different authentication mechanisms and I wanted to be sure of which one you had.

  
  
  

• Jarod.Net

  Hi Paul,

  Let me try to understand your scenario.... you have a workbook in a SharePoint Document library, and you are attempting to load it in the Excel Web Access web part correct

  The workbook loads fine if you are logged in with an account that has Full Control access to the file, but you cannot load the workbook if the account has Read permissions to it

  Is that the case The important part being that your file indeed resides in a SharePoint Document Library and not an UNC path.

  
  
  

• JohnMichaelGrace

  Hi,

  Thanks for the reply. Yup, that's the case.
  But, I don't understand your meaning of "The important part being that your file indeed resides in a SharePoint Document Library and not an UNC path"

  
  In Excel Web Access web part, the workbook location is point to the Excel file which is resided in a doc. lib.

  e.g. http://moss-2/teamsite/VisitorReports/Book1.xlsx

  It is points to a doc. lib. instead of using UNC path. Any advice

  Thanks so much.

  
  
  
• Excel Services Secuirty Issue