Shared Excel Workworkbook Crashes

[hchen]

I developed a shared Excel 2000 workbook recently. The shared workbook is put on network, and many people could use the shared XL workbook and enter data simultaneously.

My problem is when more than one perple open the workbook at same time, the workbook crashes SOMETIMES when the workbook needs updating after someone else saves the workbook. I set up the workbook automatically updates every 5 minites. The workbook is quite simple and is run in Windows 2000. I am using MS Office 2000 (SR-1). There are no conditional formating cells in the workbook. Any ideas?

Thank you in advance.

 

[shelron]

Check your settings for sharing, Tools/share workbook/advanced

I have a shared workbook that is working ok but I have the following settings,

shared changes win

update when saved

 

[shelron]

sorry, should have read


"the changes being saved win" not "shared changes win"

 

[hchen]

Thank you Shelron.

I set up the Shared workbook settings using VB in order to make sure that everyone has got thae same settings. By the way, some people may view and enter data using terminal server.

I set up the setting for conflict resolution as:
.ConflictResolution = xlOtherSessionChanges

The VB coding is as follows:

Private Sub Workbook_Open()
On Error Resume Next

With ActiveWorkbook
.AutoUpdateFrequency = 5
.AutoUpdateSaveChanges = True
.KeepChangeHistory = True
.ChangeHistoryDuration = 30
.ConflictResolution = xlOtherSessionChanges
.PersonalViewPrintSettings = False
.PersonalViewListSettings = False
End With
'
With ActiveWorkbook
.HighlightChangesOptions _
When:=xlAllChanges, _
Who:="Everyone", _
Where:="=DataRange"
.HighlightChangesOnScreen = True
.ListChangesOnNewSheet = True
.AcceptAllChanges
End With
End Sub

 

[shelron]

hchen,

you're over my head,

I have had good and bad experiences sharing workbooks. The one I currently am referring to works well for me, but I used the menus to create it, not vb,

good luck, ron