Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing Queries In Excel 2007
I have several queries in an Excel 2007 workbook pulling data from Access. I
need to modify the properties of the queries, but when attempting to do so with Edit OLD DEB Query, I receive a message of "Could not use "; file already in use." and the query properties do not update. Any ideas on how to solve? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing Queries In Excel 2007
You can to to the Data tab and under Connections see all the connections for
the queries on all the tabs. If you go to the usage tab you can change the properties, on the definition tab you can change the query (from the command text or the Edit Query button even though you get the message that the query cannot be edited using the Query Wizard when using the button), the connection and the parameters. Hope this helps. -- "If you can''t have the best of everything make the best of everything you have"...BIAKathy "T Stephens" wrote: I have several queries in an Excel 2007 workbook pulling data from Access. I need to modify the properties of the queries, but when attempting to do so with Edit OLD DEB Query, I receive a message of "Could not use "; file already in use." and the query properties do not update. Any ideas on how to solve? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameter queries in Excel 2007 | Excel Discussion (Misc queries) | |||
Cant scroll when editing cell (Excel 2007) | Excel Worksheet Functions | |||
Locked for Editing - Problem - Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 queries | Excel Discussion (Misc queries) | |||
2007 office Excel link Access Queries | Excel Worksheet Functions |