There's an option on the tools|share workbook|advanced tab
that can be used to update changes--but the other users have to save the
workbook for those to be seen. (So it's not real time either.)

(and I, too, have never used Shared workbooks in real life.)

There's a big list under "Features that are unavailable in shared workbooks" in
excel's help.

Conrad Carlberg wrote:

"Vindell" wrote in message
...
Thank you Conrad. However, I had additional problems. For instance, one of
the workbooks that I wanted to share kept giving me a "open as read only"
box. My only thought is that that particular workbook has been saved to be
a
read only file, however I could not figure that out.

In my experience, one sees that "open as read only" message when another
user has the file open, and it's not been shared. In that case, Excel will
not allow a subsequent user to save the file with the same filename and to
the same path (IMHO, the "read only" message is misleading). So I suspect
that another user had already opened the (unshared) workbook.

Also, is there a way where I can see the work that is being input into the
Excel file in real time.

Not that I know of -- not without re-opening the workbook, which doesn't
classify as "real time.".

The problems you describe are among the reasons I avoid sharing workbooks
and use a combination of a database and Excel instead.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005

--

Dave Peterson