Unable to open Excel workbooks in Excel from SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-666721%22%20slang%3D%22en-US%22%3EUnable%20to%20open%20Excel%20workbooks%20in%20Excel%20from%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666721%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20several%20issues%20with%20opening%20Excel%20files%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ECan%20open%20Excel%20in%20Browser%2C%20but%20when%20selecting%20'Open%20in%20Excel'%2C%20I%20get%20the%20message%20'an%20unexpected%20error%20occurs'%2C%20OR%20the%20workbook%20is%20blank%20when%20it%20opens%20in%20Excel.%3C%2FLI%3E%3CLI%3EWhen%20clicking%20on%20the%20name%20of%20the%20workbook%2C%20it%20opens%20as%20Read%20Only%20in%20the%20Browser%2C%20and%20I%20have%20to%20then%20select%20the%20option%20to%20Edit%20in%20Browser%20-%20when%20I%20do%20that%2C%20it%20then%20asks%20me%20to%20Save%20a%20Copy%20and%20it%20creates%20a%20copy%20of%20the%20file%20with%20'editable'%20at%20the%20end%20of%20the%20file%20name%20-%20this%20is%20not%20ideal!%20We%20have%20loads%20of%20spreadsheets%20shared%20across%20many%20teams!%3C%2FLI%3E%3CLI%3EA%20colleague%20has%20hidden%20some%20columns%2C%20but%20when%20she%20goes%20back%20into%20the%20file%2C%20they%20appear%20again!%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20would%20be%20so%20grateful%20for%20any%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-666721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-666886%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20open%20Excel%20workbooks%20in%20Excel%20from%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666886%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180667%22%20target%3D%22_blank%22%3E%40Margaret%20Dullaghan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20what%20I%20experienced%20before%2C%20the%20file%20permissions%20on%20SharePoint%20was%20read%20only%20so%20you%20won't%20be%20able%20to%20edit%20the%20file%20unless%20you%20download%20the%20file%20and%20edit%20it%20on%20your%20own%20local%20Hard%20Drive.%20Online%20file%20permissions%20won't%20allow%20you%20to%20edit%20the%20file%20as%20if%20you%20make%20changes%20it%20will%20affect%20the%20online%20file%20on%20sharepount.%20Contact%20the%20filder%20owner%20and%20ask%20them%20to%20check%20your%20permission%20on%20the%20share%20point%20for%20any%20specific%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EDav%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-666918%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20open%20Excel%20workbooks%20in%20Excel%20from%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F340070%22%20target%3D%22_blank%22%3E%40Dav1988%3C%2FA%3E%2C%20thanks%20for%20your%20reply.%26nbsp%3B%20All%20users%20have%20got%20edit%20access%2C%20not%20read%20only.%26nbsp%3B%20I%20am%20the%20site%20collection%20administrator%20and%20even%20I%20am%20getting%20the%20same%20issue!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667352%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20open%20Excel%20workbooks%20in%20Excel%20from%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667352%22%20slang%3D%22en-US%22%3EPlease%20let%20know%20if%20the%20spreadsheet%20has%20any%20formula%2Fmacros%3F%20Also%2C%20which%20version%20of%20office%20is%20installed%20on%20your%20computer%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-667623%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20open%20Excel%20workbooks%20in%20Excel%20from%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667623%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F147286%22%20target%3D%22_blank%22%3E%40Nitesh%20Ranjan%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20a%20lot%20of%20documents%20and%20I%20have%20just%20tried%20opening%20a%20Word%20document%20and%20it%20is%20doing%20exactly%20the%20same%2C%20I%20am%20getting%20the%20same%20error%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20in%20some%20of%20the%20spreadsheets%20there%20are%20formulas%20but%20no%20macros.%20Some%20spreadsheets%20have%20neither!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone

 

I am having several issues with opening Excel files:

 

  1. Can open Excel in Browser, but when selecting 'Open in Excel', I get the message 'an unexpected error occurs', OR the workbook is blank when it opens in Excel.
  2. When clicking on the name of the workbook, it opens as Read Only in the Browser, and I have to then select the option to Edit in Browser - when I do that, it then asks me to Save a Copy and it creates a copy of the file with 'editable' at the end of the file name - this is not ideal! We have loads of spreadsheets shared across many teams!
  3. A colleague has hidden some columns, but when she goes back into the file, they appear again!

I would be so grateful for any help!

 

Many thanks in advance!

4 Replies
Highlighted

Hi @Margaret Dullaghan 

 

From what I experienced before, the file permissions on SharePoint was read only so you won't be able to edit the file unless you download the file and edit it on your own local Hard Drive. Online file permissions won't allow you to edit the file as if you make changes it will affect the online file on sharepount. Contact the filder owner and ask them to check your permission on the share point for any specific file.

 

Thank you

Dav,

 

Highlighted

@Deleted, thanks for your reply.  All users have got edit access, not read only.  I am the site collection administrator and even I am getting the same issue!

Highlighted
Please let know if the spreadsheet has any formula/macros? Also, which version of office is installed on your computer?
Highlighted

@Nitesh Ranjan Thanks for your reply.

 

There are a lot of documents and I have just tried opening a Word document and it is doing exactly the same, I am getting the same error message.

 

Also, in some of the spreadsheets there are formulas but no macros. Some spreadsheets have neither!