Forum Discussion
Office 2016 - Excel 'Not Responding' message.
Just for the notes - So far the issue has not reoccured after it got solved with windows auto-updates on 7/12/2017.
and the issue is back....so many parameters to think through to investigate and feel very tired unfortunately.
Today opened an MS-Word file from SharePoint Online, editted and saved it. While closing it gave the usual messages for adding comments during check-in etc. It checks-in the file successfully but MS-Word keeps the document open and stuck with 'Not Responding' message. It's just a 2 page document, no graphics. It sounds so odd and wrong, looks like SharePoint is able to complete it's action but forgets to pass on the buck to MS-Word and it keeps on waiting. If SharePoint has habbit of forgetting then maybe apps should ping it multiple times.
Notes:
1. Along with SharePoint, it happens with document stored on One-drive also (no surprise!).
2. It DOES NOT happen with documents stored on local drive on my laptop.
3. The document seems to change itself to "Read-Only" during these last hand-shakes between SharePoint and MS-Word. But on OneDrive that's not the case.
4. Even though the message is in MS-Word, but it hangs the Excel as well.
5. OffCAT real-time logging doesn't show a thing. Just one sentence 'Logging Started' nothing after that.
6. When running full repair of office - doesn't show any running status. Made me think for a moment the full repair removed the office from my machine.
For Document Stored on SharePoint Online:
For document stored on OneDrive:
I know this issue has not been talk about for a little while. I am in the process of moving everyone slowly onto the 365 platform and software suite. We current have it on about 300 users spread across different countries and departments. We are having a similar issue with excel 365 on the desktop. We have not deployed out Onedrive or Sharepoint out the whole company. Only IT has Onedrive and Sharepoint sites \ Doc libraries. The Users if anything maybe using the built in Onedrive in windows 10, not the sync client. This issue does not deal with files on either one of those sources, but on File shares that are on the network. These files are 45MB+ excel files that have a lot of data and formulas in it. The files opens just fine but when they start a big changes with the formula and math need to be done excel will be become frozen for 5+ mins or crash. This also happens when they try to save the file. I have looked at event log and gather data from there. when we copy the file down to the users desktop and use it, we see not issues and i ask them to try and make it crash and it spins for 5 secs and it is fine. So we are seeing this before we even ask the users to move away from file shares to sharepoint online / Onedrive. Is there setting we can set to help performance issues?? As i see this becoming a even bigger issue when people start doing multiple edit at the same time to a document this size on Sharepoint or OneDrive that is shared.
Let me know if there is any more information you need.
Today opened an MS-Word file from SharePoint Online, editted and saved it. While closing it gave the usual messages for adding comments during check-in etc. It checks-in the file successfully but MS-Word keeps the document open and stuck with 'Not Responding' message. It's just a 2 page document, no graphics. It sounds so odd and wrong, looks like SharePoint is able to complete it's action but forgets to pass on the buck to MS-Word and it keeps on waiting. If SharePoint has habbit of forgetting then maybe apps should ping it multiple times.
Notes:
1. Along with SharePoint, it happens with document stored on One-drive also (no surprise!).
2. It DOES NOT happen with documents stored on local drive on my laptop.
3. The document seems to change itself to "Read-Only" during these last hand-shakes between SharePoint and MS-Word. But on OneDrive that's not the case.
4. Even though the message is in MS-Word, but it hangs the Excel as well.
5. OffCAT real-time logging doesn't show a thing. Just one sentence 'Logging Started' nothing after that.
6. When running full repair of office - doesn't show any running status. Made me think for a moment the full repair removed the office from my machine.
For Document Stored on SharePoint Online:
For document stored on OneDrive: