Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Workbook with different queries on each worksheet
I have several workbooks to which I copy the current spreadsheet to create a
new one. Then I edit the query to the database (only on the new worksheet) to reflect a different time period. In 2003 it was a breeze, I just editted the query , saved it and returned the data to the worksheet. Piece of cake. In 2007, the onnly way I have found to do this is to open the properties of the connection, change tabs and select edit query , make changes and return data and OK my way out of the all the pop-ups. IS there an easier way to do this? Why are the external connection options grayed out? Should I be doing this some other way in 2007? -- Bettie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook with 20+ queries of Access is TOO BIG | Excel Discussion (Misc queries) | |||
How many queries are there in my entire Excel workbook? | Excel Discussion (Misc queries) | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Excel 2003 This Workbook contains queries to external data | Excel Discussion (Misc queries) |