View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Autofilter does not work on protected w/s even when "checked to allow" ??

Good question Ron!

Well, the answer is "same problem!" on both the 2003 & 2007 installs.

I even selected all "Allow User To" boxes on the 2003 machine.
Then I saved the file after selecting the boxes to ascertain if that
would make any difference, it did not.

EagleOne

"Ron de Bruin" wrote:

Hi EagleOne

On the particular w/s, I checked the dialog box to allow Autofilter.


I test it for you in Excel 2007 and save the file as 97-2003 and I can filter with no problems

Do you see the problem when you open the xls file in 2003 or in 2007 ?