Forum Discussion

Anonymous

Aug 01, 2018

Excel error

Hello, I came here because I find something wrong with Excel 2016 and Excel Online. It's impossible to make changes in Excel 2016 and Excel online at the same time. When one of the files is open i...

Silver Contributor

Aug 02, 2018

Hi Claire

In my understanding, this is by design. You cannot co-author documents across Excel 2016 app and Excel Online at the same time, it has to be one or the other app.

I would suggest the following advice to avoid co-authoring issues by using Excel Online if you are collaborating in real-time with other users, and Excel 2016 app when you need more features (Excel Online is limited in features) to update the workbook with.

Hope that helps!

Cheers

Damien

Anonymous

Aug 02, 2018

Hi Damien!

Thanks for your answer!
I will do that with my co-workers, but it also does that when I'm alone on the file, do you know why?

Claire

SergeiBaklan
Diamond Contributor
Aug 02, 2018
Claire,

It's hard to say. I've seen few times error like this, Excel says the file is locked by yourself but actually it's opened by another person, as I remember in Excel 2013. I guess something was wrong with SharePoint caches. But that's quite seldom.

If you have that permanently and you know for sure nobody else is working with file - when have no guess