Software

Ask something
Question Locked

Excel 2003 AutoFilter Freezes up

0 helpful
2 replies

by erwin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When i'm working with Excel 2003, i would click on autofilters and it would work. but i would go back and click on a filter again and it freezes up rendering the filters useless. I would have to go back and turn the filters off and then on again to clear it. I have over 1200 cells on the worksheet. but i don't thing that the size of the worksheet is the issue. Can anyone tell me why the AutoFilters freeze up? The system has a 2.9Ghz CPU with 1GB RAM running XP Pro.

2 replies

by rob miners

Go to Control Panel, System Properties and take note of the amount of RAM. Now you need to make sure that the Pagefile is equal to 1.5 times the installed RAM.

Go to Control Panel, System Properties, click on Settings under Performance, click on the Advanced tab, click on Change under Virtual Memory.

This discussion is closed to new replies.