Hi Harish,
What I am thinking on this that you are putting all of the execution work
on the event of closing of the workbook. Keeping this thing in mind, can
you try and look forward to move some of the execution(s) before closing of
the workbook. Might be like change of some values or happennin
Hi all,
Thanks for reply.it still doesn't work for me.
Dilip I wrote following formula in Workbook_BeforeSave()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
after writing these formula in Wo
Hi Harish
If this is related to excel VBA code, then you can use following which I use
generally to fasten the execution of the code.
Speed up code and stop screen flickering:
==
Sub NoScreenRePainting()
Application.ScreenUpdating=False
'Your code here.
Hi Harish,
How long does the the workbook take to do a re-calc?
Press F9 to see.
XL usually re-calcs before saving (I think)
Regards - Dave
Date: Thu, 4 Jun 2009 15:52:04 +0530
Subject: $$Excel-Macros$$ Re: Performance issue when I save excel file
From: bhatibablu.ms...@gmail.com
To
Hey Dilip,
Thanks for reply, but it doesn't work for me.
I have observed that this is problem with *only *this excel file.I
tried on *different system*(more than 10 system), same problem occurs.I also
tried to save this excel file when no other file was being used,but same
probl
Hi Harish,
Check if this problem occurs only with Excel. If not, then go to Task
Manager (Alt + Ctrl + Del) and check how many programs are running in
background and how much is the memory consumption by them. Now you can
control them as per your needs.
For windows, Go to run and type "msconfig"
