Has anyone encountered an issue like this before:
I've created a very basic map plotting 39 places in England using Longitude and Latitude points.
I have a table that accompanies the map, and when you select one of the 39 places on the map, I want this to update the table to show only values for this selection.
I've set up the map as a filter but for some reason, only 7 of the 39 work when selected.
I decided to extract the data and save the file as a packaged workbook, to send to a colleague to investigate. However, when I extract the data and save as a packaged workbook and open in Reader or Desktop, everything works as it should do. All 39 places on the map filter other sheets correctly.
So I guess my question is, why would my original desktop version not work, but by saving it/extracting the data, it works perfectly?
For additional information, I am connecting to a live SQL server data source.
Edit: Added screenshots. I don't have this problem when I extract data and save as a packaged workbook. All the filters work.