Workbook unexpectedly closing as soon as it is opened.

Jaywalker

New Member
Joined
Jan 21, 2005
Messages
2
Can anyone help?

I'm a sys admin on an old NT 4.0 network running Office 97. One of our users is having a problem in that everytime he opens a specific workbook, it closes unexpectedly.

This sometimes happens with shared workbooks, and the fix is normally to unshare the workbook, save it and then share it again to clear any lock files. This hasn't worked at all in this case.

All other users can open and use this file (even those with exactly the same permissions), but it keeps kicking him out.

If he logs onto another PC on the same network he gets the same problem. I have given him a new profile, and reset the reg key out of sheer desperation.

Has anybody got any ideas at all!?
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

starl

Administrator
Joined
Aug 16, 2002
Messages
5,984
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Are there any macros attached to the workbook?
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,984
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Different versions of Excel? Workbook could be corrupt.
Have you opened Excel in safemode then tried opening the workbook?
Can the user open the workbook when it is *not* shared?
No error messages???
Do you open the workbook directly or open Excel then the workbook?

what reg key did you reset?
 

Forum statistics

Threads
1,147,689
Messages
5,742,633
Members
423,745
Latest member
rtaylor1987

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top