Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I modify a QueryTable after it has been inserted into Excel?

April 26, 2017Excel inserted

0

Posted

How do I modify a QueryTable after it has been inserted into Excel?

1 Answer

0

Posted

Currently, the only way that Office Connector supports the ability to modify a QueryTable is by allowing the user to edit the SQL text directly. In order to edit the SQL text for a query, you must have the Tech Support toolbar turned on. To turn on the Tech Support toolbar, click the Edit Preferences toolbar button: That brings up the Preferences dialog box. Check the Display technical support toolbar buttons checkbox and click OK: Now your toolbar should have the SQL editor button and other additional toolbar buttons: If you click the SQL editor button, it will bring up the Select QueryTable dialog: Double-click the QueryTable whose SQL text you wish to modify to show the SQL editor dialog: Edit the text how you see fit and click Save. You should see the query immediately update in Excel. If the query goes blank, then you probably have a syntax error in your SQL text. Bring up the editor again and look for inconsistencies.