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 ?
|