Copy Worksheet, Change Query Parameters 2007 vs 2003
 

In Excel 2003, I had a workbook that contained several worksheets. Each
worksheet pulled data from an MS Access database, but I used MS Query to
change the parameter to pull only data for that one program.

When I added a program, I would copy one of the previous worksheets, and
just change the program number in the new worksheet, then rename the
worksheet.

In Excel 2007, when I copy a worksheet and just change the query parameter,
it changes both the original worksheet and the new worksheet query to the
same parameter.

I believe this has something to do with the connection, but I just can't
figure it out or find any previous post that references this problem.

Please help. these are fairly complicated queries and such, and I really
don't want to re-create the wheel every time I get a new program.

Thank you in advance.

Leslie