Excel crashes opening Shared Worksheet

  • Thread starter Thread starter Jack Connolly
  • Start date Start date
J

Jack Connolly

I have a shared worksheet on a file server. There are about 20 different
users using it. The file is in office 2003 file format. Some users are using
office 2003 some are using office 2007. When opening, some users get a crash,
3 times in a row, followed by a practically empty worksheet the third time.
The file is shared for multiple users. when they crash, their name shows up a
bunch of times as having the file currently open. Turning off file sharing
resolves the issue with all users.
turning it back on will sometimes stay resolved, but othertimes not. *right
now, its not resolving* but either way, the issue comes back. It is different
users each time, and different PCs. sometimes seems to follow the domain
username, sometimes not.
Jack Connolly, R. EEG T.
Technical Specialist
Childrens Hospital Boston
 
Jack
Does the workbook have VBA?
If so be sure to use codecleaner
(http://www.appspro.com/Utilities/CodeCleaner.htm) or manually export
and re-import the modules. (need to unshare it first.)
You should unshare it every couple of days to clear out the history.
Realistically shared workbooks have always been dangerously unstable,
trying to edit in a mixed environment will add to that.

Do all those users really need simultaneous read/write access?

Is there anyway you could split the workbook so only a couple of people
need access to each part?

Is there any fancy user interface stuff in there? If so maybe that could
be moved to a read only component that writes to a workbook in the
background?

Cheers
Simon
Excel development website: www.codematic.net
 
Hi Jack,

I've got the same issue, I solved it, by changing the Username in Office, by the domain name of the users. (Eg; if the user is loggin in with U.Sername , then in Office this should also be U.Sername and not User Username).

This should work :)

Grtz
 
Back
Top