Filters freezing program

[Guest]

I have a Inventory spreadsheet with filters. I have used it for a couple of
years now with no problems. Now every time i use a filter it freezes Excel
and I have to close it and lose any changes. Is there anything I can do to
fix this?

 

[pfsardella]

I had a similar problem a few months ago. I surmised that Excel uses
an internal counter to track shapes. Each time that you AutoFilter,
this counter ratchets up until it hits approximately 65,500, whereupon
an out-of-bounds error occurs.

To test my theory, I created a new workbook with junk data. After each
Autofiltering, I ran a subroutine that checked the numbering
(counting) of the AutoFilter shapes. It was ratcheting upwards.

I've also had problems with other workbooks that use a lot of
filtering. The only solution I could come up with was to recreate the
workbooks .

Below is the thread that tells part of the story.

http://groups-beta.google.com/group...ead/thread/7526161243ee4285/6b2e8b8e13f31bd4?

HTH
Paul