• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unable to apply filters in excel 2003


New Member

I have a specific file which has multiple sheets, and data in each sheet is linked to the other / master sheet through vlookup (basically update master, all other sheets get updated).

In this unprotected file, I am not able to apply auto filter (data->filter->auto filter). The menu itself gets disabled.

Wheres if I open a new excel, I am able to apply data filter. If I copy data from any of the previous files sheets into the new workbook, data filter gets disabled. I am not able to add data validation also (data->validation).

Can you suggest me what could be the issue?

thanks and regards

Augustine AR