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: excel-macros@googlegroups.com
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 problem was
occurred.I concluded that it is not a system problem.
This excel file has to be distributed widely.So i need a solution
which works on any system.
I think this problem because of some variable which is used in macro,
but i don't know which variables/methods create this problem.
Thanks,
Harish
On Thu, Jun 4, 2009 at 2:14 PM, Dilip Pandey <dilipan...@gmail.com> wrote:
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" and now you can control the programs
to run automatically or to run in background
Other way could be, check your startup folder and remove the un-wanted programs
from there.
If you find issues with this, then Alternatively, you can go to run and type
"regedit" and search that program and remove it from the machine.
There may be other issues and then there may be other solutions as well. Let me
know if you have some.
Thanks,.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Jun 2, 2009 at 5:19 PM, Harish <bhatibablu.ms...@gmail.com> wrote:
I have a 2 MB workbook containing multiple sheets, formulas. A toolbar
have been also implemented and status bar also is being used in VBA
code.
My problem is that I try to save the excel file, it takes too much
time(around 40 sec) in saving.
Machine also hang-ups when this excel file is being saved.
Initially I thought that Workbook_BeforeSave() takes much time,but
after analyzing I came to know that this function also consumes very
less time(around 1 sec).
Please help me to solve this issue.
Thanks in advance,
Harish
_________________________________________________________________
Get the latest news, goss and sport Make ninemsn your homepage!
http://windowslive.ninemsn.com.au/article.aspx?id=813730
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
