Page 1 of 1
Excel hangs whenever spreadsheet is closed
Posted: Fri Sep 25, 2009 4:39 am
by 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?
Re: Excel hangs whenever spreadsheet is closed
Posted: Fri Sep 25, 2009 7:25 am
by 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?
Re: Excel hangs whenever spreadsheet is closed
Posted: Sat Sep 26, 2009 1:28 pm
by Martin Ryan
Have you got SP3 of 2003? There were quite a few issues resolved in the service packs of Excel.
Martin
Re: Excel hangs whenever spreadsheet is closed
Posted: Mon Sep 28, 2009 4:39 am
by 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
Re: Excel hangs whenever spreadsheet is closed
Posted: Mon Sep 28, 2009 7:11 am
by 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.