Excel Shared Workbooks

[Guest]

Our office uses a few shared workbooks, and for some reason, when you check
the 'share workbook' menu, users are still officially there, even though
according to the 'task manager' they don't have anything open.

We were told that it might be because of an older version of excel, but we
upgraded to Office 2007 and even the brand new 07 workbooks have the same
problem!

Any ideas/suggestions?

 

[Guest]

I wish someone had answered you. I am also interested in the answer. I hate
to believe that Excel can not more elegantly be shared among 4 project
managers. Where they can have it open and update/save and merge at the end
of the day. Where one person reviews any conflicts found.
Share workbook teases that this is possible. Sharepoint teases that this is
possible but I have not gotten any demonstration of it and all I can do is
experiment to make it do what is slyly written in help files.

did you ever get your answer?

 

[Guest]

no. But I'm glad to hear that it's not just me.

I wish someone had answered you. I am also interested in the answer. I hate
to believe that Excel can not more elegantly be shared among 4 project
managers. Where they can have it open and update/save and merge at the end
of the day. Where one person reviews any conflicts found.
Share workbook teases that this is possible. Sharepoint teases that this is
possible but I have not gotten any demonstration of it and all I can do is
experiment to make it do what is slyly written in help files.

did you ever get your answer?

 

[Guest]

I'm having the exact same problem. Also, the shared workbook we're using
keeps losing data. Just this morning we lost an entire manager's report
AGAIN. I guess these problems are due to some fundamental flaw in the way
excel handles shared workbooks.

I really wish someone could tell me how to keep this from happening.

 

[Steve Vincent]

I have also been experiencing a multitude of Excel workbook sharing problems
on a network, chronically for the past 12 years. I have never found any real
answers to the issues, which are many: changes not being saved, data lost,
and the most recent, comments/notes disappearing in other cells when a
comment/note is entered in an independent cell. And on and on. These
problems have occurred on a Novell network, and now they have cropped up
again on an Active Directory network. If anyone reads this posting and
thread, and knows of a source for answers to problems with sharing Excel
workbooks on a network, I would be most grateful. Excel is used for many
very important data handling applications in many corporations around the
world, and the plethora of sharing problems is very surprising. Looking
forward to some answers! Thanks in advance.

Steve