Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query - 2 Parameters | Excel Discussion (Misc queries) | |||
How do I change the Excel 2007 default Page Setup parameters? | Setting up and Configuration of Excel | |||
How do I change the datasource location for a query in Excel 2003 | Excel Discussion (Misc queries) | |||
Query Parameters | Excel Discussion (Misc queries) | |||
How to show query parameters on an Excel page header or worksheet? | Excel Discussion (Misc queries) |