Do you want to remove all your recent searches?

All recent searches will be deleted

Watch Later
Add to

How to Enable Remote Collaboration on Excel 2010

6 years ago97 views - Microsoft Excel is a powerful tool for business use, but did you know you can collaborate with others on a workbook? Setting these options up can be difficult, if you don't know where to look.

Microsoft Excel 2010 has brought web-based collaboration to the desktop client. Enabling this will allow you to collaborate on a spreadsheet with people across the Web, eliminating the need to email a file back and forth while waiting for everyone to add their components one-by-one.

To enable this feature, you'll need to select the Review tab using the ribbon at the top of the Excel window. From there, you'll see an option for you to share your workbook. Select the options to allow changes by more than one user and Workbook Merging. This should bring up a set of configurable options to refine your collaborative experience. Add your intended collaborators via their email address(es) and you're ready to go.

Setting up a collaborative workbook in Excel 2010 is a great way to save time and energy sending a copy of the spreadsheet to multiple people, awaiting their changes, and trying to keep up with which version of the document you have at any given time.

With GoToManage from Citrix, I was able to log in to my father's machine located several states away from my home office, set the collaborative options, and show him how to get this done without even having to log in to my desktop computer. I did it all from my iPad thanks to a free app from Citrix. GoToManage is a great way to handle day-to-day tasks, troubleshoot ongoing issues, and monitor critical IT resources from anywhere in the world.

You can try GoToManage free for 45 days by using the coupon code PIRILLO45 here:

Report this video

Select an issue

Embed the video

How to Enable Remote Collaboration on Excel 2010
<iframe frameborder="0" width="480" height="270" src="//" allowfullscreen allow="autoplay"></iframe>
Add the video to your site with the embed code above