Share a company workbook-Good idea or asking for trouble?
 

I have an Excel document that we use at work as a Project Portfolio
Management tool; basically it's our 'shop floor plan', with all 300+ IS
resources and all the projects they are working on with time allocations. It
contains 6 worksheets, a couple of these for 'Named Ranges'. It's updated by
30 or so managers and project managers. There are multiple macros across the
column headings to allow users to sort by resource, by manager, by project,
etc. and get allocation totals and sub-totals.

I've not dared put the document in 'share' mode, fearing that folks
concurrently working in differing sorts, and possibly even updating the same
information might be risky. Problem is that there's a lot of contention for
access to the document. So€¦.I'm questioning whether my concern is
well-founded. Do you see a problem with my setting this document up to be
concurrently updated?

Any thoughts related to the situation explained above would be greatly
appreciated!

Thanks!
Jugglertwo