乐分享 加入收藏  -  设为首页
您的位置:生活百科网 > 知识百科 > 正文

目录

1,如何让多人同时编辑共享文件夹里的EXCEL表格

如何让多人同时编辑共享文件夹里的EXCEL表格

1、首先在excel功能区点击“审阅”切换审阅选项,点击“共享工作簿”。如下图所示: 2、点击excel的“文件”按钮,在文件菜单中,打开excel选项对话框。如下图所示: 3、在excel选项对话框点击左侧红框框中的“信任中心”,打开信任中心设置,在信任中心对话框点击左侧红框框中的“个人信息选项”,然后取消勾选“保存时从文件属性中删除个人信息”,一路点击确定。 4、回到第一步点击“共享工作簿”,弹出“共享工作簿”设置对话框,勾选“允许多用户同时编辑,同时运行工作簿合并”,然后切换到高级选项下;

2,怎么能够实现多人同时编辑共享文件夹中的内容?

1、首先,打开Excel表格,在工具栏点击“审阅”——“工作共享簿”。
/iknow-pic.cdn.bcebos.com/b8014a90f603738df92a9183bd1bb051f819ec2b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b8014a90f603738df92a9183bd1bb051f819ec2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/b8014a90f603738df92a9183bd1bb051f819ec2b"/>

2、点击表格左上角“文件”,点击左边列表中“选项”。
/iknow-pic.cdn.bcebos.com/4610b912c8fcc3ced7ab54929c45d688d43f2023"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4610b912c8fcc3ced7ab54929c45d688d43f2023?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/4610b912c8fcc3ced7ab54929c45d688d43f2023"/>
4、点击左边列表中的“信任中心”。
/iknow-pic.cdn.bcebos.com/a8014c086e061d956026aa9975f40ad162d9ca2b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a8014c086e061d956026aa9975f40ad162d9ca2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/a8014c086e061d956026aa9975f40ad162d9ca2b"/>
5、然后点击“信任中心设置”。
/iknow-pic.cdn.bcebos.com/b7fd5266d016092483453fbada0735fae6cd342a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b7fd5266d016092483453fbada0735fae6cd342a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/b7fd5266d016092483453fbada0735fae6cd342a"/>
6、点击“个人信息选项”,将“保存时从文件属性中删除个人信息”取消勾选,点击“确定”。
/iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed9639abde76f0f736afc31f2a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed9639abde76f0f736afc31f2a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed9639abde76f0f736afc31f2a"/>
7、再次点击“审阅”,点击“工作共享簿”弹出一个对话框,点击“编辑”栏,勾选“允许多用户同时编辑。
/iknow-pic.cdn.bcebos.com/95eef01f3a292df501a231b4b2315c6034a8732a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/95eef01f3a292df501a231b4b2315c6034a8732a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/95eef01f3a292df501a231b4b2315c6034a8732a"/>
8、设置完成,表格的最上方出现“共享”字样即可。
/iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dcdd771230c311728b461028cc"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dcdd771230c311728b461028cc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/71cf3bc79f3df8dcdd771230c311728b461028cc"/>