怎么样共享Excel工作簿才可和同事共做一张表【Excel教程】
<span style="color: black;"><strong style="color: blue;">回复[</strong><strong style="color: blue;">目录</strong><strong style="color: blue;">]学习113篇Excel教程</strong></span><p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyNDmBGzGRtxMH3iaH2Y4ymrult7ic3Qxz8fZib5LJF78otFT256MRPNwoSMUx1E4frA4Lsiaj2P6XwSA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">全套Excel视频教程，<span style="color: black;">微X</span>扫码观看</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">纸质化资料，极为不方便<span style="color: black;">查询</span>，近期<span style="color: black;">机构</span>想把<span style="color: black;">有些</span>历史资料尽可能实现电子化管理，那就少不了人工补录资料。我的天啊，这任务刚好安排给我，个人单打独斗，猴年马月<span style="color: black;">才可</span>补录完整呀？假如<span style="color: black;">将来</span>一切都<span style="color: black;">能够</span>共享，你最想共享什么？我只想表达，<span style="color: black;">思虑</span>当下，最想共享我的excel工作簿，让同事<span style="color: black;">一块</span>分担完成我的补录信息工作。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">那<span style="color: black;">怎样</span>共享呢，<span style="color: black;">咱们</span><span style="color: black;">一块</span>来<span style="color: black;">认识</span>下吧！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">现假设<span style="color: black;">机构</span>甲、乙、丙、丁四成员在局域网完成同一Excel工作簿的信息补录。操作<span style="color: black;">过程</span>如下：</span></p>第1步：<span style="color: black;">创立</span>共享文件夹<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）<span style="color: black;">创立</span>“信息补录”文件夹。<span style="color: black;">按照</span>需要，<span style="color: black;">选取</span>在甲、乙、丙、丁其中一用户的电脑上<span style="color: black;">创立</span>“信息补录”新文件夹（假设<span style="color: black;">选取</span>丁用户电脑<span style="color: black;">创立</span>）。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（2）设置网络路径共享。右键单击“信息补录”文件夹，<span style="color: black;">选取</span>“属性”，在弹出的“信息补录属性”对话框中，<span style="color: black;">选取</span>“共享”选项卡，单击“共享”按钮，设置共享用户和权限级别，如下。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4BmU0OhvLQoQlS8xt5ymSbWdmjOzCyJhf6cZYAFMgkDhy1KEmDERGor0w/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（3）设置文件高级共享。单击“高级共享”，并赋予完全<span style="color: black;">掌控</span>、更改及读取的权限。操作如下图所示。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4BmVHtbfJlgIpJqmiaOp6zCwIfxMfBrm9TU8sKpPUZZuLdT5U2ribNs6UjQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（4）继续点击下方的“网络和共享中心”， <span style="color: black;">选取</span>“启用文件和打印机共享”“关闭<span style="color: black;">秘码</span><span style="color: black;">守护</span>共享”，并且“<span style="color: black;">保留</span>更改”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4BmaxuFh5KibRpiaiblkBSZs3LTzQmxREKorJH0huDmTQuEkZpIPMKtPY4nA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（5）单击电脑桌面右下角网络连接图标，<span style="color: black;">选取</span>“打开网络和共享中心”，在弹出的文件夹中单击“无线网络连接”<span style="color: black;">或</span>“本地连接”，再单击“<span style="color: black;">仔细</span>信息”查看Ipv4<span style="color: black;">位置</span>。将此<span style="color: black;">位置</span>告诉<span style="color: black;">另一</span>三用户，<span style="color: black;">她们</span><span style="color: black;">就可</span><span style="color: black;">经过</span>该<span style="color: black;">位置</span>找到共享文件夹“信息补录”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4BmzEhh4HCmQmkrTBeYicZm8L6xicqmTUvzMlWzibn5xJickP7urCwHf5Cm9w/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>第2步：设置共享工作簿<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">（由甲、乙、丙、丁其中一用户操作）</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）上传需要共享协作的工作簿到共享文件夹“信息补录”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（2）打开需要共享的工作簿, 单击“文件”菜单，<span style="color: black;">选取</span>“选项”命令，在弹出的“Excel选项”对话框中<span style="color: black;">选取</span>“常用”，将用户名改为所属用户的真实姓名，以便日后查看或核对修订记录。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4BmWsZDibpvmZ5RDRnMF1bm5SUXCFz5V8NzX43qJQyp9A52qaoGMic3fFHg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（3）切换至“信任中心”中的“信任中心设置”，其中“<span style="color: black;">信息</span>栏”默认选上“从不<span style="color: black;">表示</span><span style="color: black;">相关</span>被阻止内容的信息”及“启用信任中心日志记录”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4Bmryx3nFz8iczTSVyQdR0R01A608STsibwppVs10TCsG0pZcQTI3kEiaVRA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（4）切换至“个人信息选项”<span style="color: black;">或</span>“隐私选项”，取消“<span style="color: black;">保留</span>时从文件属性中删除个人信息”的<span style="color: black;">选取</span>，其他默认，<span style="color: black;">而后</span>点击“确定”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4Bmc6wKrnPNvD5whpE1L5mTkw8xVGhroKUZe5hPv3F4nzZZviaXs8MnCCQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（5）退出“Eccel选项”后单击“审阅”选项卡，在“更改”组中单击“共享工作簿”按钮。在弹出的“共享工作簿”对话框的“编辑”选项卡上勾选“<span style="color: black;">准许</span>多用户<span style="color: black;">同期</span>编辑，<span style="color: black;">同期</span><span style="color: black;">准许</span>工作簿合并”复选框。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4BmshnWFbaGCibTaPALAVdwlibbP5Fqia1lTXiaG5voliasflK0Zp9ibLIPKj0A/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（6）接着切换至“高级”选项卡，<span style="color: black;">意见</span><span style="color: black;">选取</span><span style="color: black;">保留</span>修订记录，并将天数设置大<span style="color: black;">有些</span>，以方便日后<span style="color: black;">查询</span>修订记录，例如输入100天。其他可按默认设置。单击“确定”按钮，Excel会提醒用户<span style="color: black;">保留</span>工作簿，单击“确定”按钮<span style="color: black;">就可</span>，之后，此工作簿即<span style="color: black;">作为</span>共享工作簿。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyuyrmicNhqam23Ts3gmb4BmYz8qic1luPIic2dOMUesAv9VxHQRIsBy5Ashu7NYYyfFG9beo3dian6jA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">工作簿共享后，其他用户可<span style="color: black;">经过</span>自己电脑网上邻居进行<span style="color: black;">同期</span>编辑、浏览约定的工作簿。</span></p>第3步：提前约定<span style="color: black;">处理</span>冲突<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）在协同录入同一工作表数据时，甲、乙、丙、丁用户可事先简单约定好输入的单元格区域。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（2）<span style="color: black;">倘若</span>多用户的编辑内容之间<span style="color: black;">出现</span>冲突，<span style="color: black;">例如</span>甲用户修改了A1单元格的内容，并进行了<span style="color: black;">保留</span>，乙用户此后又修改了A1单元格，当乙用户进行文件<span style="color: black;">保留</span>时，会弹出对话框询问<span style="color: black;">怎样</span><span style="color: black;">处理</span>冲突。此时乙用户<span style="color: black;">能够</span>跟甲用户相互协商后进行处理。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">温馨提示:工作簿共享后，Excel的<span style="color: black;">有些</span>功能会受到限制。若<span style="color: black;">运用</span>中要用到<span style="color: black;">有些</span>限制功能的话，以我个人的经验，可先跟其他用户沟通好，<span style="color: black;">大众</span>都<span style="color: black;">保留</span>好后，临时取消下工作簿共享，待<span style="color: black;">尤其</span>操作完成后，再恢复共享<span style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最后留给<span style="color: black;">大众</span>思考下，<span style="color: black;">平常</span>中<span style="color: black;">那些</span>工作场景适用工作簿共享协作呢？留言区告诉<span style="color: black;">博主</span>~~~</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">想要全面系统学习Excel，不妨关注部落窝教育《<span style="color: black;">1星期</span>Excel直通车》视频课或《Excel极速贯通班》直播课。</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">《<span style="color: black;">1星期</span>Excel直通车》</strong></span>视频课</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">包括</span>Excel技巧、函数公式、</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">数据透视表、图表。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">一次购买，永久学习。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最实用接地气的Excel视频课</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">《<span style="color: black;">1星期</span>Excel直通车》</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">风趣易懂，快速<span style="color: black;">有效</span>，</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">带您7天学会Excel</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">38 </strong></span><span style="color: black;">节视频大课</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">（已更新完毕，可永久学习）</span></strong></span></strong></span></strong></span></strong></span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">理论+实操一应俱全</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">主讲老师： 滴答</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMw9HqsFgNibg3wrgklctzmiaton0P5Rr0efiaGAzyScpqGmtKMTX4m2HhJh3Kalv4BqrRgmDsZGzLcWw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Excel技术大神，资深培训师；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">课程粉丝100万+；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">研发</span>有《Excel小白脱白系列课》</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 《Excel极速贯通班》。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">原价299元</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">限时特价</span><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">99</span></strong></span></span><span style="color: black;">元，随时涨价</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">少喝两杯咖啡，少吃两袋零食</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">就能习得受用<span style="color: black;">一辈子</span>的Excel职场技能！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 长按下面二维码立即购买学习</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMx9yReibpHJNVMvB4RK0ibylhqJV98X8KPzyuDoGR91TqrCvRqWORseRvyAxNs4lZj72RITRTgeV1Kg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">购课后，加<span style="color: black;">微X</span>：603830039领取课件</span></p>
认真阅读了楼主的帖子，非常有益。 真情实感，其含义为认真了、走心了的意思，是如今的饭圈常用语。
页:
[1]