<div>
As always : Worked!!! Thanks.<br />
<br />
Is there any documents avalable on performance tuning for Excel any where?<br />
<br />
<br />
<br />
<br />

</div>


As always : Worked!!! Thanks.

Is there any documents avalable on performance tuning for Excel any where?






<div>
thanks for the grade<br />
<br />
<a href="http://www.cpearson.com/excel/optimize.htm" rel="ugc">http://www.cpearson.com/excel/optimize.htm</a><br />
<br />
among other goodies there's an optimizer here<br />
<a href="http://www.erlandsendata.no/english/downloads/tools.htm" rel="ugc">http://www.erlandsendata.no/english/downloads/tools.htm</a><br />
<br />
:O)Bruintje
</div>


thanks for the grade

http://www.cpearson.com/excel/optimize.htm [http://www.cpearson.com/excel/optimize.htm]

among other goodies there's an optimizer here
http://www.erlandsendata.no/english/downloads/tools.htm [http://www.erlandsendata.no/english/downloads/tools.htm]

:O)Bruintje

<div>
Well, initially I did not understand the importance of giving grade. I thought it was in line with complexcity. Now I do. You deserved what I gave you this time.<br />
<br />
Thanks for the sites. They are good. <br />
<br />
Thanks again.<br />
<br />
Pulki Shah<br />

</div>


Well, initially I did not understand the importance of giving grade. I thought it was in line with complexcity. Now I do. You deserved what I gave you this time.

Thanks for the sites. They are good.

Thanks again.

Pulki Shah


<div>
<div class="content wysiwyg-content">
I have a excel spreadsheet which is populated from the data thru OLE from mainframe. The spreadsheet contains 40 coulmns atleast 50% of which have fromula's. The number of rows returned are around 6000+. It takes almost 10 minutes to populate the spreadsheet. I need to sped it up. Using tools - option- calculation-manual is not a option as I believe that impact all the excel spreadsheet on the server. <br />
<br />
Can any one suggest some thing? the formula's mostly uses the Excel's native funtions which includes vlookup and arithmatic/logical functions. <br />
<br />
Thanks.
</div>
</div>


I have a excel spreadsheet which is populated from the data thru OLE from mainframe. The spreadsheet contains 40 coulmns atleast 50% of which have fromula's. The number of rows returned are around 6000+. It takes almost 10 minutes to populate the spreadsheet. I need to sped it up. Using tools - option- calculation-manual is not a option as I believe that impact all the excel spreadsheet on the server. 

Can any one suggest some thing? the formula's mostly uses the Excel's native funtions which includes vlookup and arithmatic/logical functions. 

Thanks.

Speeding up the excel spreadsheet population

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.