Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

Use Google Spreadsheets to Collaborate on Excel Worksheets


Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada.

The tip in this show is from Learn Excel from MrExcel.

On today's episode of Call for Help, an unusual tip for Excel. Excel is a great spreadsheet program. However, it does a lousy job of sharing spreadsheets. If you turn on sharing, then a whole host of features become disabled in Excel.

The new Google Spreadsheet does not have many features, but it does allow two people to collaborate on the same spreadsheet at the same time.

To get started, go to http://www.spreadsheets.google.com. You will need a Gmail account in order to get a Google Spreadsheet account.

After you sign up, you will have a simple online spreadsheet. It can accommodate up to 10,000 cells. There is not support for charting, pivot tables, or VBA. The real power, though, is the ability to share the spreadsheet in real time with another person. To begin sharing, click the Share This Spreadsheet link in the upper right.

Invite others to edit the spreadsheet.

You will then be able to simultaneously work on the spreadsheet.

When you are finished, you can download the spreadsheet back to your computer as an .xls file.

Google Spreadsheets are a great way to collaborate on smaller Excel workbooks. For the BEST TV show on technology, check out Call for Help.

This tip was originally published on August 18, 2006 and aired on TechTV in Canada and Australia on August 18, 2006.

The permanent URL for this page is http://www.mrexcel.com/tip130.shtml.

If you are looking for show notes from another episode, visit my complete list of TechTV appearances.

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.