Sharing Excel Workbooks

[Guest]

How feasible is it to share an Excel Worksheet with multiple users that is in
a constant dynamic state? The worksheet is used for scheduling and is
changed constantly through out the day. Is Excel capable of handling such
dynamic changes by multiple users?

 

[Dave Peterson]

Excel thinks it is.

Tools|Share workbook

But there are lots of things that can't be done with shared workbooks.

And there are lots of people who don't trust shared workbooks.

You may want to consider using an application that's made for multiple
simultaneous updating -- a real database program (Access???).

 

[Guest]

Thank you, Dave. My past attempts at sharing Excel workbooks has resulted in
some of those failed attempts. We have been using Excel as a front end
device for an Access application that we created, but we are out growing the
Excel front end. You have saved me several futile attempts and wasted hours
trying to make it work.