Opening shared spreadsheet generates "Access Violation" error

[Guest]

We have an Excel shared spreadsheet on a LAN drive that has recently started
to cause Access Violation errors when opened. When sharing is disabled, the
file opens without errors. This error occurs only on some PCs, and for any
user on those PCs, including administrative user accounts. On the PCs where
the file opens without error, any user can open the file.

I've compared the versions of Excel and the set of installed patches between
the PCs that have the problem and those that don't, and haven't found any
obvious differences that could be causing this behavior. Any suggestions for
other things to look for?

thanks!

 

[Guest]

I have the same problem on my Novell LAN and MS-Office Excel 2000 (9.0.3821
SR-1).

What I've noticed is that for XP clients excel crashes while on W2K clients
it doesn't. When the problem arises I noticed the file "inflates" on size due
to the sharing information; if I open the file and check for the sharing book
option I can see the usernames of those who used the file (even when they're
not using it any more), and they're not able to open the book even if I
delete them from the sharing list.

The only practical and quick solution is to copy and paste every sheet's
data on a new document, but if you copy the whole sheet the sharing
information and hence the crashing remains. But this happens very often and
I'm shure there's have to be a solution. I hope this info might help someone
to post a solution.

Regards
Hector