Opening Excel 2007 in Sharepoint

[imiddleton25]

I am trying to put a Excel 2007 spreadsheet on Moss 2007 site but i need to default option if double clicked to open in excel not try opening in the browser (Thats another story as its broken).

I need staff to read only no editing

When i set as read the options for opening go from Edit in excel to view in web browser. If I up permissions to contribute its fine but then they can edit.

|Any ideas how i get round this???

[apearce]

How is the file linked - are you getting staff to click on it from the document library or through a URL you've put in a content editor?

 

Is it a csv, xls or xlsx file?

 

A.

[imiddleton25]

Its in a document library xlsx file

[rpwillis]

Have you looked at the "Browser-enabled Documents" setting under Document Library Settings | Advanced?

 

Richard

SalamanderSoft Limited

[imiddleton25]

Open in the client application is selected

 

it only does it when you restrict the viewing to read or lower

[apearce]

what browser version you using? Does it do the same in IE and firefox or in IE 6 ro IE8 beta?

[rpwillis]

It's possibly to do with versioning. Check the version of the file and see if there's only a minor version saved. If so you have 2 possibilities:

1. Publish a major version.

2. Change the versioning settings of the document library so that Draft Item Security is set to "Any user who can read items."

 

Richard

SalamanderSoft Limited

[imiddleton25]

Still no luck

 

using ie7

 

As it works for users with change rights and not read or view is that the normal to open in a browser when set at those permissions??

[rpwillis]

When I've put an xlsx in a document library I don't get the option to view in web browser at all, whatever the permission level. It always opens in Excel.

 

Are you using Excel Services with it?

 

Richard

[grhee]

I am experiencing the exact same issue. Users have Office 2007 in a MOSS 2007 environment. When they click on a file they are prompted to Read-Only or Edit. If Read-Only in selected, they are able to edit the file and save the modified version back to the library.

 

I'd like avoid using Check In/Check Out due to the users in our organization. Does anyone have a solution or suggestion? Thanks

[cabanuta]

Have you found a fix for this? I am having the same issue, no excel services enabled, users with read rights cannot open the xlsx in excel - it opens in browser and they get "web access error". This happens on one library only, and only for those with read rights. They would need contribute rights to open it in excel, but i dont want them to be able to edit. The library is set with set with "open in client app". any other library is fine, xlsx open in excel regarless if users have read, contribute or full rights. Please let me know if you found a cause or a fix for this. Thanks. Edited October 27, 2009 by cabanuta