Microsoft Queries - copying and changing criteria PROBLEM
 

I have an extensive spreadsheet I am working with that uses Microsoft
Query to get info from Access and populate various "buckets" depending
on certain paramaters. I have one sheet per cost center. I created the
first sheet and then used the copy sheet function to create the
others, changing the cost center in the query criteria for the various
sheets. My problem is that when I run a macro I recorded to refresh
the external data, for some reason, some of the sheets revert back to
the first sheet's criteria. So, they have the wrong cost center info.
Has anyone ever encountered this before? It seems intermittant, as it
effects different sheets at different times.

Thanks for any help.

-Jennifer