+ Post New Thread
Results 1 to 11 of 11
Virtual Learning Platforms Thread, Opening Excel 2007 in Sharepoint in Technical; I am trying to put a Excel 2007 spreadsheet on Moss 2007 site but i need to default option if ...
  1. #1

    Join Date
    May 2008
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 48 Times in 45 Posts
    Rep Power
    24

    Opening Excel 2007 in Sharepoint

    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???

  2. #2
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    413
    Thank Post
    34
    Thanked 175 Times in 110 Posts
    Rep Power
    43
    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.

  3. #3

    Join Date
    May 2008
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 48 Times in 45 Posts
    Rep Power
    24

    file

    Its in a document library xlsx file

  4. #4
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    Have you looked at the "Browser-enabled Documents" setting under Document Library Settings | Advanced?

    Richard
    SalamanderSoft Limited

  5. #5

    Join Date
    May 2008
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 48 Times in 45 Posts
    Rep Power
    24

    Open in client

    Open in the client application is selected

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

  6. #6
    apearce's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    413
    Thank Post
    34
    Thanked 175 Times in 110 Posts
    Rep Power
    43
    what browser version you using? Does it do the same in IE and firefox or in IE 6 ro IE8 beta?

  7. #7
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    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

  8. #8

    Join Date
    May 2008
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 48 Times in 45 Posts
    Rep Power
    24

    no luck

    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??

  9. #9
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    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

  10. #10

    Join Date
    Jan 2009
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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

  11. #11

    Join Date
    Oct 2009
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    excel opening in browser when read only

    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.
    Last edited by cabanuta; 27th October 2009 at 01:21 AM.

SHARE:
+ Post New Thread

Similar Threads

  1. problems opening excel document
    By PEO in forum How do you do....it?
    Replies: 6
    Last Post: 7th March 2008, 09:53 AM
  2. Excel 2007 - Calculations
    By wesleyw in forum Windows
    Replies: 3
    Last Post: 14th January 2008, 01:22 PM
  3. Excel 2007 Chart Types
    By wesleyw in forum How do you do....it?
    Replies: 0
    Last Post: 12th September 2007, 11:01 AM
  4. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  5. Excel 2007
    By wesleyw in forum Windows
    Replies: 0
    Last Post: 22nd June 2007, 03:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •