SharePoint 2016 Server - Randomly can't open Excel Online workbooks in edit mode

SamusCroft 1 Reputation point
2020-08-03T13:52:43.437+00:00

Since mid-week last week, our users are having issues opening up Excel files in the browser from our SharePoint 2016 on-premise server. They get this error:

15166-image.png

Here is what I've tried so far:

  • Rebooting the server that hosts the Excel Services account
  • Rebooting the SQL server
  • Going through all of the service accounts on the SQL server and checking that their permissions were correct. (making sure that db_owner and public were checked).
  • Making sure all of the service accounts' permissions in Central Admin were correct
  • doing an IISRest

Is there anything else we should be trying?

Edit: I should also mention that this error happens at random times. Sometimes the workbooks open successfully in edit mode without any issues, sometimes you can't open them at all without getting that error. Sometimes you can open up the workbook fine, but as soon as you try to edit in the browser it gives that error.

UPDATE: We solved the issue. Our server that hosted Excel Services needed more storage space. We increased the storage space and now it's working fine.

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,955 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 47,216 Reputation points Microsoft Vendor
    2020-08-04T07:42:54.177+00:00

    @SamusCroft
    Based on your description, you add more storage space for server to solve this issue.

    I summarize your solution as an answer for other users to solve this issue better. You can accept it as answer if you would like.

    If you solve the issue by yourself next time, you can summarize the solution as an answer and accept it as an answer instead of updating the original post. It will do great help to those who meet the similar issue in this forum.

    Thanks again for your contribution.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.