Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 755
  • Last Modified:

Can't open excel doc with excel services in Sharepoint 2010

The is one spreadsheet on our SHarepoint 2010 site which does not open with Excel services. It shows the attached error and after clicking yes, opens with normal Excel. It's not end end of the world, but is really annoying after a few months.  Excel Services
0
Mayogroup
Asked:
Mayogroup
  • 2
1 Solution
 
Jamie McAllister MVPArchitectCommented:
Sheet protection is not supported so you need to remove it.

End of this article tells you how to remove it;

http://spreadsheets.about.com/od/excel2007tips/qt/080528_protect.htm

After that you should be set.
0
 
MayogroupAuthor Commented:
Sheet protecting is not enabled on the Spreadsheet. So not sure why this error occurs.
0
 
Jamie McAllister MVPArchitectCommented:
Difficult for me to say from here of course. I'd check that there aren't any workbooks or tabs you are missing in this sheet. I tend to trust these error messages.

Otherwise, re-create the sheet. Unless SharePoint likes this it won't play ball. There's no switch to flick in SharePoint that will get rid of this.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now