I have a workbook that uses the subtotals option to work out the average of our delivery times.

There is a query that runs over the AS/400 to generate the data which gets imported to a Hidden sheet on the workbook.

However if I open say a workbook for August and then open another one for September the data from the most recently opened workbook displays in both Augusts & Septemebrs workbook.

I hope this makes sense. The only way I have got round this is by opening 2 instances of excel then opening the workbooks in different instances of excel.

Does anyone know whay this might be?