Excel file from SharePoint crashes on save

Question

Hello,

Whenever I want to edit an Excel file which is located in SharePoint folder and then save it, crash appears.

Steps that I want to do:

1. Open the file

       

     2. Press "Edit WorkBook"

     3. Edit some values

     4. And press "Save" (to save it back on SharePoint)

Unfortunately, after step 4 error occurs.

 I would need a solution for this problem if anyone has an idea how to solve it.

Thank you!

-Office 356 for Business

-Windows 7 Enterprise

Answer 1

Hi Saso Pavlic,

Please check if you have installed any custom add-ins in Excel.

• In Excel, click File > Options > Add-Ins.
• At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go.
• Clear the checkbox for any enabled COM add-ins. select OK.

Note*: If disabling the COM add-ins alleviates the issue, try enabling them one at a time to test for the problem add-in.*

If removing custom add-in didn’t solve the issue, please provide the following information:

1. Provide the screenshot of Office 2016 Product Information. To get this screenshot, open Excel/Word 2016 on your system, click File>Account, capture the screenshot of all the information mentioned under Product Information.
2. Do you get the crash error when you work and save the Excel sheet saved on your local system?
3. When you open the workbook from ODFB/SharePoint online, does this issue happen with all the file format or it is restricted to .xlsm sheets?
4. Is it happening with a specific sheet .xlsm sheet or all the macro enables sheets gives the same error.
5. Please check if the same issue appears to other Office applications such as Word or PowerPoint.

Thanks,

Neha

Answer 2

Hi Nega Singh

The solution for disabling Add-ins worked, and now I can save it without any problems.

Thank you for fast response,

Saso