Excel 2007 Basic Filters Problem
 

In Excel 2007 upgrade from Excel 2000. (from a office upgrade to Office 2007
Basic)

The scenario is. Largeish spreadsheet loads ok. on Applying a filter you
then filter on certain data (one value from the drop down) it works as
expected. But when you then select all it takes around 2 minutes.

No responsive and resumes life after 2 minutes approx

To test to see if it was the spreadsheet or machine we tried it on one
machine (Excel 2007 Pro) it was great / as expected.

Excel 2007 Basic Filters Problem
 

fixed..

we applied service pack 2 and it now works why not sure but it works

Simon

"Simon Whale" wrote in message
...
In Excel 2007 upgrade from Excel 2000. (from a office upgrade to Office
2007
Basic)

The scenario is. Largeish spreadsheet loads ok. on Applying a filter you
then filter on certain data (one value from the drop down) it works as
expected. But when you then select all it takes around 2 minutes.

No responsive and resumes life after 2 minutes approx

To test to see if it was the spreadsheet or machine we tried it on one
machine (Excel 2007 Pro) it was great / as expected.