Here, click the button next to the Name field to open the Connection Properties window. This will open the External Data Properties window.Highlight cell A1 (or any cell associated with the query), then the click the Data tab and select “ Properties”.Open a spreadsheet in Excel that contains a working Microsoft Query.

If you've created a spreadsheet with an Excel Query in the past and would like to change what data is being returned on the report, you can follow the steps below to update the query: Although, the need may arise to view real-time data for inventory, sales, purchasing, and more via Microsoft Excel, on-demand. Microsoft Excel, when linked to an Acctivate database via ODBC, can be a useful tool to quickly return data from Acctivate.Īcctivate QuickBooks Inventory Software was designed to automate, track, simplify and securely manage growing business needs all within the software's interface.

Modifying an existing Microsoft Query in Excel Modifying existing Microsoft Queries in Excel.

How to get power query in excel 2007