Spreadsheets Working SOOOOOO Slowly

[AstToTheRegionalMGR]

I don't know what I'm doing to cause this, but my spreadsheets are running SOOOOO slowly as they get more complex. It is really unbearable. I use a large amount of INDEX(MATCH)) formulas that look through entire columns, and I'm wondering if that's the cause? On some other spreadsheets, I've changed those lookups to look through the entire column within tables, and it seemed to help a little, but not a ton.

Is there anything else I can do?!?

[MarvinP]

Hi Second in Charge,

If you workbook is slowing down any you suspect because you are using the ENTIRE column, you might benefit from these two sites:
http://www.excelforum.com/excel-gene...oo-slowly.html
and
http://www.excel-easy.com/examples/d...med-range.html
The above site shows how to limit your "Full Column" to a Dynamic Named Range which might be much faster to use in your formulas.