Excel hangs whenever spreadsheet is closed

[telula]

Hello,
It seems that sometimes when we close a spreadsheet, it hangs the entire excel application.This is causing frustrations among our users.
In certain spreadsheets, we have a N_Disconnect macro that is called on Workbook close and it still causes the same problem. We are using TM1 V9.0SP3 on excel 2003.Has anybody got a solution?

[jim wood]

The only thing that might be happening is that in your excel options you have auto calc switched off but you still have calc on save selected? Are you saving upon exit?

[Martin Ryan]

Have you got SP3 of 2003? There were quite a few issues resolved in the service packs of Excel.

Martin

[telula]

Jim,
I have the following codes on
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "{DEL}"
Application.OnKey "{Backspace}"
Run ("N_DISCONNECT")
Application.CutCopyMode = False
ActiveWorkbook.Saved = True
ActiveWorkbook.Close
Application.DisplayAlerts = False
end sub
and
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
end sub
I'll have to check if we have SP3

[jim wood]

Apologies for being a little vague but the setting I refered to are in excel. You get to them by selecting tools then options. From there click on the calculation tab. (To be able to do this you must have the a sheet open. Having the one open that crashes is even better.)

Jim.