ExcelBanter - Filtering Fails

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filtering Fails (https://www.excelbanter.com/excel-discussion-misc-queries/247099-filtering-fails.html)

RussellT

Filtering Fails

I've converted to excel 2007 and find that filtering large amounts of data
causes excel to lock up. This didn't happen in 2003. Why?

Dave Peterson

Filtering Fails

I don't know why, but maybe you can turn calculation to manual and see if excel
behaves better.

Remember to recalculate before you trust the results of your formulas.

RussellT wrote:

I've converted to excel 2007 and find that filtering large amounts of data
causes excel to lock up. This didn't happen in 2003. Why?

--

Dave Peterson

All times are GMT +1. The time now is 12:21 PM.