'Excel 2016: Error accessing file. Network connection may have been lost
we are developing an Excel 2016 Workbook using VBA. I descrivbe the error from my side, but it occurs at several independent Computers - even at the customer's where the Worksheet used to work fine...
I have a Worksheet containing some cells and a Button which is bound to a VBA macro.
Now, when I change tge size, the position or the text of the button or when I change the macro's name I get the error
"Excel 2016: Error accessing file. Network connection may have been lost"
No network connection is used in that place and the file is stored locally.
Giving goolge some tries I found many posts concerning Project 2000 and PowerPoint 2000, but not for Excel of any versions. (The given causes are that a Project or PP master has been corrupted)
When I save my Workbook, open it on another computer with Excel 2010, save it there all seemed to be fixed. Several hours of work and several file saves later I get the same error.
Does anyone know this error in Excel 2016? Can I deliver more content so you can help me?
Solution 1:[1]
I just came across this error, using the option to "Open and Repair" from the drop-down on the button on Excel's "Open" dialog fixed it for me.
Solution 2:[2]
"Open and Repair" as suggested in the answer from
mike spurrmay work in some instances so its worth trying. However, sometimes it serves as only a temporary fix and soon the error recurs.Frequently the issue stems from incorrectly implementing, ahem, the
IMPLEMENTSstatement. So if your source code has classes with theIMPLEMENTSstatement check these solutions also:
Solution 3:[3]
Rename the end of the file for example rotadocs - call this rotadocs.old and save it.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | mike spurr |
| Solution 2 | |
| Solution 3 | sen wun |