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

Jennifer

How did you change the cost center in the query criteria?

What is the macro you use to refresh the external data?

What version of Excel are you using and what OS?

"Jennifer" wrote in message
om...
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