more-arw search

Q&A Forum

Is it possible to manage an excel spreadsheet online and have additional people have access to it?

Mikita Patel's Profile

Answers

Topic Expert
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO, SBAConsulting.com) |

Use Google Docs

Bryan Frey
Title: VP Finance/Corp Controller
Company:
(VP Finance/Corp Controller, ) |

I will second Wayne's recommendation. Google spreadsheets are simple to access and use. Let's face it everyone has a gmail account (unless they're stuck at AOL) and what you typically want with a shared doc (spreadsheet or otherwise) is easy access.

The one caveat is around complexity and high order functions. If the spreadsheet is highly complex with rarely used excel functions, it may be easier to go with office 365 per Jaime below. Google spreadsheets are great for about 98% of excel functionality. However, when you need that final 2%, it pulls up short. That's exceedingly rare, however.

Bob Scarborough
Title: CEO
Company: Tensoft, Inc.
(CEO, Tensoft, Inc.) |

Or Office 365 - which is Excel online.

Topic Expert
Jaime Campbell
Title: Chief Financial Officer
Company: Tier One Services, LLC
(Chief Financial Officer, Tier One Services, LLC) |

The latest features of Office 365 include real-time multi-user editing. If two people are editing the same Excel spreadsheet at the same time, the cell that the other party is editing shows up on your screen with a thin red outline.

If you want collaboration that doesn't necessitate such up-to-the-second information, try Dropbox or Box with a desktop sync. Two people can both access the file and work in it as long as it's not at the same time.

Google Docs is workable as long as some of the niftier features of Excel aren't needed.

Topic Expert
Charley Kyd
Title: Founder
Company: ExcelUser
(Founder, ExcelUser) |

Take a look at Excel Web App. Here's a description for Excel 2010:
http://office.microsoft.com/en-us/web-apps-help/introduction-to-excel-web-app-HA010378338.aspx

And here's a blog that describes the Excel 2013 version:
http://blogs.office.com/b/microsoft-excel/archive/2013/11/06/we-ve-updated-excel-web-app-what-s-new-in-november-2013.aspx

Also, another possibility is using shared workbooks, as described here:
http://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HA102748977.aspx

Honestly, I haven't tried any of these options. But they seem to be popular solutions.

1311 views
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.