EXCEL LASTEST UPDATE:How can 2 people use the same file at the same time? Shared/View option is gone

New Contributor

At work, we have updated to Microsoft Business 2016. We use excel to create data reports and we all update the report at the same time using the shared file option in View. With the new update, the shared option is not there. Well at least I can't see it. Is there a way to make the file shared to where we all can update the file at the same time?

6 Replies

Hi @TrishaKPB , file share is still exists, but now that's legacy functionality. More advanced is co-authoring, aka share on OneDrive or SharePoint. Please see details here https://support.office.com/en-us/article/what-happened-to-shared-workbooks-150fc205-990a-4763-82f1-6...


You may have to look into this. I believe any shares you have previously created would have to be set-up again anyway. Also I think that with MS Business, you need to have SharePoint &/or OneDrive set for your business, to get it working correctly.

@Nauthstar , file share works correctly with Excel upgrade and, as a rule, that's not necessary to re-share old shared files. The only, this functionality is hide now.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies