Download the 10 workbooks and re-publish with context filter on.
it is the most straight forward solution.
thanks lewis, but in this corporate enviroment i cant do that. its controlled by another group and i need to fix the problem in the main template workbook that gets connected to the other data sources....
is this a known issue of having the filter removed from context ? can you give another recommendation, is there anything i can do within the calculation, etc?