0:00
Have you ever needed to work on the same
0:02
Excel file with another person without
0:04
having to send the file back and forth
0:06
through email or messaging? In this
0:08
guide, we will focus on how to share a
0:10
workbook in Excel 365 so that multiple
0:14
people can work on the same file more
0:15
efficiently. This feature helps you
0:17
collaborate in real time or
0:18
asynchronously without duplicating
0:20
versions or constantly updating files
0:23
manually. By default, the shared
0:25
workbook feature is not visible in
0:27
Excel's main interface, so you need to
0:28
enable it manually. To do that, first go
0:31
to the file menu, then select options.
0:33
Inside the options menu, navigate to the
0:35
quick access toolbar section. Within
0:38
this section, find the dropown that says
0:39
choose commands from and change it to
0:41
all commands to see the full list of
0:43
Excel tools. Scroll through the list or
0:45
use the search function to locate the
0:47
share workbook legacy command. Once you
0:50
found the share workbook command, click
0:52
add to include it in your quick access
0:53
toolbar. Press okay to confirm. Now the
0:57
share workbook button will appear at the
0:58
top of your Excel window, ready to use.
1:01
Click on the share workbook button. Then
1:03
check the option that says allow changes
1:05
by more than one user at the same time.
1:08
This is what enables workbook sharing.
1:10
After selecting it, click okay again to
1:12
apply the setting. At this point, your
1:15
workbook is now ready to be shared. You
1:18
can go to the file menu and use the
1:19
share option to send access to others.
1:21
Everyone with access can work on the
1:23
same file at the same time without
1:25
having to email updated versions. This
1:27
is especially useful for internal
1:29
collaboration where teammates need to
1:30
contribute to or review the same data.
1:32
Try using this feature with your
1:33
colleagues so you can co-edit
1:34
spreadsheets efficiently without back
1:36
and forth file sharing. This approach
1:38
greatly simplifies teamwork and helps
1:40
ensure everyone is always looking at the
1:42
latest version of the workbook.
