[Music]
hi this is Manny fresh for another
tutorial today I'll be showing you guys
how to reactivate the legacy sharing of
a workbook in Excel 2016 by default
Excel 2016 removed the sharing
functionality now they use a new
functionality called co-author that
requires Microsoft onedrive service so
if you want to reactivate the legacy
sharing so other people could work in
the same workbook without causing any
problems what you need to do is you need
to go to file options and then you want
to go to customize ribbon on the left
side here let's go ahead and click on
all tabs actually all commands and just
click on the first one here and then
type the letter S and scroll down until
you see share workbook legacy now on the
right side what I'm gonna do is I'm
gonna click on the last one here
and then just click on new tab and then
I'm gonna rename this to sharing and
then this one I'm just gonna name my
share workbook alright so with this one
highlight it and this one highlight it
go ahead and click Add and then click OK
what that did is it created a new tab
here on the top called sharing and then
the next step is to go ahead and click
on share workbook legacy from here you
want to make sure that this is selected
this overrides the co-authoring
experience for the new
so and this shoe working the newest
Excel - and then basically this is what
the previous Excel used to have in order
for people to be able to share workbooks
all right so from here you could go to
advanced and change the settings you
need to then click OK
and then it's gonna ask you to save the
document just gonna save it on my
desktop
alright so this is just saying that to
go ahead and turn off the feature that
you enable because they have the new
feature that uses onedrive just click on
not now now people will be able to work
on this workbook and it works like it
used to do with the previous Excel
versions if you want to add the same
functionality here to the quick bar you
could do the same theme by going to file
options quick access toolbar and then
all commands and then look for the
sharing one there you go and then just
transfer it click OK and then you're
gonna see the shared workbook option
here on the top alright so that's how
you activate the legacy sharing of a
workbook for Excel 2016 or higher thank
you for watching if you have any
questions leave your comment below and
please subscribe
you