D
DallasLDY
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
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