Excel 2016

[Robert56]

Upon opening an Excel workbook (any of thousands we use) the following message appears:

"Operation cannot be completed. Try again later." (with triangular yellow caution symbol and exclamation mark). Pressing the OK button or closing this caution allows revision of the workbook. Upon closing or saving the workbook the following message appears: (accompanied by the yellow caution symbol)"You are no longer connected to this file. Another user may have removed you from it, or saved over it. To preserve your unsaved work, click OK, and save the shared workbook with a different name. You can then open the original shared workbook again, and merge in your changes from the copy of the workbook that you saved. For information about merging networks click Help." Pressing OK brings up a third caution: C\UsersBob O\Desktop\.doc    File not found. Check the file name and try again."

This completes a sort of circular reference blocking changes to the workbook.

This started recently after an update was peremptorily made upon shutdown and occurs inconsistently, as if a prior user were blocking access randomly. Help!!

[#2]

Hi ! First question i may ask: Why is it you get the last message about a ".doc" when it is an Excel Workbook? Next question: Did your company migrate all your files from file server to O365 without asking about the different (thousand) relationships between the most important Workbooks? If so, I would strongly recommend asking your adminstrator to repair your several workbooks connections.

Are you online, when you open your Workbook? Or working offline? Then your connections can´t reach out and this is the main cause. Try it online.

And I ask myself if you had an Office 365 Training before working with your files? Maybe that you are not anymore allowed to open this particular workbook because you are not in the right permission group to work on that file. Or on that other workbooks / Documents, which have been related to your permission level is the wrong one... Thousand workbooks can cause thousand questions and the most relevant one is about your permissions to work on those files.

Did you have a training about Office 365 so far? If not, ask your fellow collegues, if they have the same problems as well. Then its a time to send a request to your HR or your IT to set up Office 365 Trainings, concerning your new dos and donts. Before training request you could do this today: Try to go to the Excel local Application on your PC, without any workbook. Then try to click HOME Tab => Open. In that dialog box pls. click on the small arrow within that "open..."-Button. Take the very last option "Save and Repair...".

Follow the instructions.

If it doesnt open, because there are tooooo many lost relations and VBA Starting codes within, just exit your excel, open your workbook with pressing SHIFT key while you open it. With that shortcut you can temporarily block all VBA Codes running on open event. 

Then - when its opened - go to your HOME Tab again. Check the "Information". In the right bottom corner you ll see, what connections are in your workbook. You have to ask your administrator, if you don't have permission to open the several linked files in there. Send him/her a screenshot of this dialogue. I give you a screenshot here as example.

Hope that helps. Pls give a Like, if it does. Greets, Eva.

[#3]

Hi Robert,

Please check this support article https://support.microsoft.com/en-us/help/2744335/you-are-no-longer-connected-to-this-file-error-when... if helps.