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
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...@gmail.com
From: Amit Desai (MERU)
Sent: Wednesday, August 15, 2012 8:48 AM
To: excel-macros@googlegroups.com
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
