More on this tomorrow, but just in case anyone has seen this before. I have a workbook that carries 3 different data sources, each extracts from sizable Excel spreadsheets. On one worksheet, I filter the date range of records to a 3 month subset, using date range starting 1st November 2011. I later move to another worksheet that draws on the same data source, but there is no date field in my filters shelf - so I should see everything since 1st Jan 2011 as present in the data. In practice, the same date range appears.
There are globals set on the other data sources, but no common names - and my filter shelf has no globals on it at all.