This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In my spreadsheet, the filter is picking up unnecessary data that I do not want to be included in my data range. I have read through all of these suggestions and have zero blank cells, no extra rows/columns, etc. Has anyone found a solution to this error or can recommend something that worked if this same problem happened for you. Thank you in-advance.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
If you wish, you can send a copy of the workbook to
hans dot vogelaar at gmail dot com
Hans, thanks for getting back to me so quickly. Unfortunately, I do not have access to any of those websites that let you share a file (blocked due to firm compliance and regulation). However, I am happy to elaborate in more detail on the specifics of the issue and the routes I've taken to troubleshoot.
Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.