Collaborate on Excel in real-time? Any alternatives if not possible?

Fabio · 16-06-2016 11:05AM #1

Hi all,

Hope you are doing well!

In my workplace we have to use an Excel sheet to keep track of progress on various jobs we are all doing. We call it the "status sheet". However, I can't enter anything on it if someone else in the office has it open. This inevitably leads to confusion and whatnot and things can get missed. It seems like a very old problem and no manage nor supervisor has tackled it.

Is there anything I can use which will do the same job as Excel but will allow real-time collaboration? Google Docs is the obvious answer but I know they won't allow it. The Excel sheet we use is currently kept on a shared folder on a server if that is any use.

Anything out there at all?

Thanks in advance

TPF2012 · 16-06-2016 11:11AM

Google Drive . A shared sheet on Drive between anybody that needs to access it. I have used it before, keeps track of all change to doc and by who.

gctest50 · 16-06-2016 11:22AM

There should be on-site only versions of nearly everything - lots would be unhappy about sending data off into the web

http://kanbantool.com/kanban-tool-on-site

http://static.kanbantool.com/onsite/KTOn-Site-Datasheet.pdf

henryporter · 16-06-2016 11:23AM

Depends on which version of Excel you have - if 2010 or greater try this: https://support.office.com/en-ie/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61.

Fabio · 16-06-2016 11:35AM

Thanks everyone - I will bring those ideas up and see where they go.

Collaborate on Excel in real-time? Any alternatives if not possible?

Comments