Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Autofilter
Name: patho Date: March 16, 2005 at 08:39:22 Pacific OS: win 2000 pro, office xp CPU/Ram: p4
Comment:
Hi all,
I have recently compiled a sheet to track hours etc, it has a lot of formulae in it so I've protected all the relevant cells, On the option box I've checked allow users of this workbook to use autofilter. However when one of my colleagues has tried to use auto filter they can't they fileter box is showing but it doesn't drop down, and when they go to data/filter/autofilter it is greyed out, is this office XP not working with earlier versions or am I doing something wrong
Name: patho Date: March 16, 2005 at 13:17:19 Pacific
Reply:
I have just emailed file home where I use Excel 2000 and if you protect the sheet you cannot use autofilter. I need my colleagues to be able to use autofilter and I also need to be able to protect the cells that contain formulae. I have considered writing a query that would return the data but I'm not sure if the query will refresh on a pc that doesn't have it installed.
Summary: Hi everyone, I'm working on a large worksheet on Excel 2003, with over 1000 rows. Each row consists of one movie, and each column provides information for each movie, eg. origin, director, genre etc. ...
Summary: I'm assuming you want to filter on an individual value, e.g. filtering on 3 would hide rows 3 and 4. I don't know of a way to use Excel's AutoFilter feature with this type of data, but this macro will...
0 
