• 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

    Hui...

  • 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

augustine_68

New Member
Hi,


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
 
Top