Sharepoint, unable to Check-Out Excel File

Hi,

My team has a sharepoint site with an Excel file (with macros). Check-In/Check-out is activated for all files.

I can click the check-out button and modify, but then there is still the "check-out" button in "file", no "check-in" button. When i click on "check-out" (so the second time), i've got an error : "We have trouble to communicate with the server". Then the ribbon asking me to check-out the file appears again. When I click on it (third time), it tells me that somebody has already check-out the file, and the e-mail address displayed is mine.

If i close the file, i am asking if i want to undo my check-out. If i say yes, the file close and it goes back to start. But if i say no, the file will be permanently locked with the message that somebody has already checked-out the file (me).

So in the last case, the file can't be recovered and all my colleagues are unable to edit it. A new file has to be created.

Of course, it works perfectly well for my colleagues and i am the only one with the problem.

Version :

Office 365 ProPlus

Excel 2016  MSO 16.0.9126.2295 32 Bits

Windows 10

Thanks in advance for your help

 

Question Info


Last updated November 21, 2019 Views 1,697 Applies to:
Answer
Answer

All my colleagues have the same version.

Indeed, the macro file can be edited in Excel Online ! I guess i was thinking that wasn't working because of a warning, but it was only because links to external spreadsheets are deactivated in Excel Online. The file is not displayed perfectly because of that but it can be edited without issue...

I also followed your troubleshooting. When deleting the cached files and doing a clean boot solved the problem ! So i tried to understand what was missing and i finally narrowed down the problem : It was the OneDrive application.

The problem occurs when the sharepoint folder is synced localy ! When i quit OneDrive in system tray or stop the sync of this folder, I can edit the file from Excel without problem.

I think there might be a bug around.

Anyway, thanks a lot for your help Zixuan

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.