Issue changing the Advance Filter

Question

Filtering has been limited to a list range. The Advance Filter appears with a filter list range that it is not possible to change. It is my list and the worksheet is not protected but I cannot change the range. When I do so a window message appears: "This command requires at least two rows of source data..."and also suggests to select a range of cells that contains at least two rows of data. When I do this nothing changes and I get the same window message.

The current data worksheet is validated but not to the current range.

The current list range has many empty columns without data and without validation.

The list range is $A$1:$DFD$1

The current columns I use are $A$1:$AP$2271

What I want is to have an auto filter that will filter all the cells without limits or with the limits I want.

Answer 1

ok Vijay I am trying dropbox. Which link I should use to include you?

Answer 2

You can put it on Google drive / Drop box or any other file sharing site. I'm not allowed to enter into a one on one communication through Skype / mail.

Answer 3

My OnDrive will not give me the option of a link but I could share via Skype or email. I could attach the file to an email or allow you to share the screen with Skype if compatible.

Answer 4

Hi Vijay,

Unfortunately I cannot post the file because is a working file and cannot be posted.

But will send you an example with the issue asap.

Answer 5

I need to have a look on your workbook to provide you the solution specific to your problem.

Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and right solution.

You can upload from Onedrive application on your computer.

If you don't have this application,

1. Login to https://onedrive.live.com/ utilizing the same Login ID and Password which you have used on this forum. (or use the installed Onedrive on your computer)
2. Click Upload in the top OR drag and drop the file here.
3. After uploading, right click the file and choose share.
4. Optional but recommended - Uncheck the Allow Editing
5. Click Get a Link.
6. Copy the link and paste the link here.