Muzzbug
Newbie
Joined: 31 Mar 2011
Posts: 1
|
 Posted: Thu Mar 31, 2011 1:22 pm Post subject: Limit to the no. of sheets that can have autofilters??? |
 |
|
Hi there. I've got a spreadsheet with quite a lot of data. It runs over 9 different sheets. I need to use autofilters on all of the sheets to isolate various sets of data, but seem to be having trouble. Autofilters are up and running on 4 of the sheets, and remain so when I shut down, and re-open the program. I am able to add autofilters to a fifth sheet, but then when I add autofilters to a sixth sheet, the filters on the fifth sheet disappear. Then, if I go to another sheet to add autofilters, the filters on the sixth sheet disappear and so on.
Is there a limit to the number of sheets that can have autofilters? Or if not, does anybody know why this may be happening?
Any help would be gratefully received!
Many thanks!  |
|
