Search This Blog- Enter the tip # or a keyword(s)

Sunday, July 30, 2017

1837. Remote Spreadsheets

I often need to share spreadsheets with remote co-workers. It would be great if we could both be looking at the same spreadsheet concurrently, and it would be even better if we could both be making concurrent changes to the data. Is this even possible?

Not only is it possible it works really well. If you live in the Google world the Google sheets application allows you to create a workbook like an excel worksheet and share it with other users. There's a share option in the upper right hand corner you insert an e-mail address and your coworkers could then look at the spreadsheet, make changes as you are making changes, and you can collaborate at the same time.

If you live in the Microsoft world Excel has an online version available at Office.com that allows you to create a workbook there where you can share that workbook with other Microsoft users and everyone involved can make updates concurrently.

This is a great way to do your work and actually it's the way that Doug and I work on our tips for the radio. We are on Google sheets at the same time I make changes on my computer and Doug sees those changes immediately on his computer. It's an easy way for us to work together and not have to share a single computer to look at the spreadsheet as we are creating these tips.

So check out Office.com for Microsoft or the Google Drive option to work with Google Spreadsheets they both work great.

No comments:

Post a Comment