External Data Query Copied and Edited Reverts back to Orig

[jj51574]

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

 

[XL-Dennis]

Re: External Data Query Copied and Edited Reverts back to Or

Hi Jennifer,

Could You please provide us with the code?

Kind regards,
Dennis