I will take a look at your file dguillett1 @gmail.com
-----Original Message-----
From: Amit Desai (MERU)
Sent: Tuesday, August 23, 2011 6:26 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Very slow performance by Excel file
I have more than 1000 formulaes...spreaded in 4 sheets...pls suggest
solutions..
Best Regards,
Amit Desai
Assistant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534
-----Original Message-----
From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
Sent: Saturday, August 20, 2011 6:05 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Very slow performance by Excel file
That's true. My memory usage shows more than 500 MB usage & my system's RAM
is 1GB!!!
How can I get rid of this issue..I have put the excel formula caln as
manual..but still performance is very slow....
Best Regards,
Amit Desai
Assistant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534
-----Original Message-----
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of XLS S
Sent: Friday, August 19, 2011 7:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Very slow performance by Excel file
Try this...
Go to "tools" -- "options" -- select "Calculation" tab -- check on
"manual" and make sure you check on "recalculate before save". this is
going reduce the time taken by excel to calculate the formulae present
in your sheet. hence increasing the performance. I'm sure that you
have lot of formulae in your sheet :-)
On Fri, Aug 19, 2011 at 10:30 AM, Amit Desai (MERU)
<amit.de...@merucabs.com> wrote:
Dear All,
I have an excel sheet of about 700 rows & column till AZ. Because of the
using formula the same is functioning very slowly. Is there any solution
to
speed up the performance of file?
My system's RAM is of 1 GB.
Best Regards,
Amit Desai
Assistant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534
________________________________
Disclaimer: This message and its attachments contain confidential
information and may also contain legally privileged information. This
message is intended solely for the named addressee. If you are not the
addressee indicated in this message (or authorized to receive for
addressee), you may not copy or deliver any part of this message or its
attachments to anyone or use any part of this message or its attachments.
Rather, you should permanently delete this message and its attachments
(and
all copies) from your system and kindly notify the sender by reply e-mail.
Any content of this message and its attachments that does not relate to
the
official business of Meru Cab Company Pvt. Ltd. must be taken not to have
been sent or endorsed by any of them. Email communications are not private
and no warranty is made that e-mail communications are timely, secure or
free from computer virus or other defect.
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
.........................
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Disclaimer: This message and its attachments contain confidential
information and may also contain legally privileged information. This
message is intended solely for the named addressee. If you are not the
addressee indicated in this message (or authorized to receive for
addressee), you may not copy or deliver any part of this message or its
attachments to anyone or use any part of this message or its attachments.
Rather, you should permanently delete this message and its attachments (and
all copies) from your system and kindly notify the sender by reply e-mail.
Any content of this message and its attachments that does not relate to the
official business of Meru Cab Company Pvt. Ltd. must be taken not to have
been sent or endorsed by any of them. Email communications are not private
and no warranty is made that e-mail communications are timely, secure or
free from computer virus or other defect.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
