We’ve got a shared workbook that we were not the creators of that isn’t filtering as it should. We need some help.

We have two similar files, SOlog and SOlog-2. SOlog-2 is the version we’re currently using, and the one that has the issue. SOlog-2 has all of the data from SOlog, plus a bunch of additional data that has been added over the last couple of years.

When using the filter function, we’re not able to filter all the data on SOlog-2. Specifically, we can only the data that was carried over from SOlog. When using the filter function, any data from SOlog is filtered at the top of the sheet, and all additional data on SOlog-2 is listed unfiltered below the filtered data.

Since we didn’t create the workbook, we’re not sure what was done (and whoever did is either no longer with the company or doesn’t remember).

We’ve checked “Queries and Connections” and “Properties” under the “Data” tab. It lists SOlog in the connections for SOlog2. Would that have something to do with it?

We’d really like to be able to filter the entire workbook. Any suggestions would be appreciated.