Thanks for all your help dear friends..
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 16 August 2012 17:33
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Tips for working on huge data in excel
You can do the following to speed up your workbook.
1). Save your file in .xlsb (Binary Format) to reduce size.
2).Remove unnecessary formatting.
3) Use Index Match instead of Vlookup()
4).Set Calculation Manual (Calculate only when required)
5).Use Name Ranges.
6).Sort you
*Sender: *excel-macros@googlegroups.com
> *Date: *Wed, 15 Aug 2012 10:46:01 -0500
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Tips for working on huge data in excel
> 2007
>
> I’m sorry, I meant to say entire ROWS.
> Post your f
cel-macros@googlegroups.com
Date: Wed, 15 Aug 2012 10:46:01
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Tips for working on huge data in excel 2007
I’m sorry, I meant to say entire ROWS.
Post your formula examples.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...
: 15 August 2012 19:52
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Tips for working on huge data in excel 2007
You did not elaborate on your formulas but I’ll bet you are using entire
columns instead of limiting to needed area.
Don Guillett
Microsoft Excel Developer
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Tips for working on huge data in excel 2007
You did not elaborate on your formulas but I'll bet you are using entire
columns instead of limiting to needed area.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmai
Subject: $$Excel-Macros$$ Tips for working on huge data in excel 2007
Dear Friends,
I need to work on huge data in excel 2007. Whenever I use any formula it
generally slows down & keeps on calculating on every move.
Please provide me tips/suggestion for improving performance.
check these links for some tips
http://chandoo.org/wp/2012/03/27/75-excel-speeding-up-tips/
http://www.brighthub.com/office/home/articles/1830.aspx
On Wed, Aug 15, 2012 at 7:18 PM, Amit Desai (MERU)
wrote:
> Dear Friends,
>
> ** **
>
> I need to work on huge data in excel 2007. Whenever I
Dear Friends,
I need to work on huge data in excel 2007. Whenever I use any formula it
generally slows down & keeps on calculating on every move.
Please provide me tips/suggestion for improving performance.
Best Regards,
Amit
Disclaimer: This message and its a
