"Excel.exe has generated errors" opening shared wrkbk

[Kevin Campisi]

We have a shared Excel 97 file on a server. It opens fine
on all pc's but one. It gives a message: "Excel.exe has
generated errors and will be closed by windows. You will
need to restart the program. An error log is being
created." OS is win2K on all pc's.

Uninstalling/reinstalling office does not help. Signing on
as different user on affected pc does not help.
The bad pc can open all excel
files, with the exception of this one shared workbook.
Any suggestions would be GREATLY appreciated.

[catherine.l...@fr.symbol.com]

>.
>To install Office 2000 PRO + Office SP3

[Eric Ellison]

Drives one crazy.

I went through the same exercise with one single user and
a shared file on the network.
Environment: Windows 2000 sp2 : Office 2000 sr1a

User gets application error when opening the sheet on her
workstation.
Copy of file (on network)to local, renamed file same
symptom.
Local Administrator on same 2000 machine can open sheet.
User can open sheet on a different workstation.
Co-workers can open sheet in their profiles on different
workstations.
Office un-install - re-install on affected machine does
nothing.

Observation:
File opened on another workstation, showed this user has
the file open about 15 times. (user did not have file open
at all). Copies and save as instances of the file showed
the same orphaned share opens.

Solution:
Delete all orphaned .tmp files in user's locals profile
folder. (I'm not sure this is required, but tmp files are
left when Excel aborts out with application errors)
Open the file on another workstation or from another users
account. Go to Tools>Share Notebook and remove all
instances of users who don't have the file open. Remove
sharing. Save file. Open file and Re-share.
Problem should go away.

Make sure that if you copy shared files or save a shared
file as a different name that you clean the shared file of
any users as having the file open when in fact it isn't
open.

>.
>