Excel program problem

[gauchofife]

Whenever I try to open a document saved on OneDrive from within Excel (File>Open), the program shuts down, restarts, and takes me back to the “File” menu without opening the document. It can open files from my local hard drive just fine. And I am able to open OneDrive files from Windows Explorer.

But if I have files open in Excel and forget to go back to Windows Explorer to open a new file, and try to open them within Excel instead, once again the whole program shuts down, restarts and brings me to the file menu. Except any files I had open have been closed and no backup copies have been saved (even though in my options settings, I have checked “Keep the last autosaved version if I close without saving.”) So I lose everything. Any help with this problem would be appreciated.

 

[sijpie]

First of all, set Autosave to ON, so any changes are immediately saved. That removes one nuisance.

I have had some issues with OneDrive in the past as well. The filenames you use, do they have special characters? Is the path very long? Try it with very simple filename, saved in the root directory on your OneDrive.