(I'm very new at this, so please be patient).

I am using EXCEL to query a 15000 item inventory file.  I have optimizer running every night.  When I open the EXCEL spreadsheet the next day, it takes 31 seconds to pull in the optimized file data, then takes 20 minutes to query the QB data file for changes.  (This is what it seems like it's doing, because for the second pass there are many "waiting for QB.." messages that flash by).

In this case just using the optimized file would be good enough (gives me quantities as of the end of the day yesterday), is there a way to have Excel only read the refreshed optimized file, but not go over the network to get the up to the minute changes from QB itself?

DSN=QuickBooks Data;DFQ=\\Gt-server\company\QBEnterprise\GOLDEN TRIANGLE_Live_for_QBE7.QBW;SERVER=QODBC;OptimizerDBFolder=C:\Program Files\Intuit\QuickBooks Enterprise Solutions 7.0\Components\QODBC\Optimizer;OptimizerCurrency=Y;OptimizerAllowDirtyReads=N;SyncFromOtherTables=N;IAppReadOnly=Y

SELECT ItemInventory.FullName, ItemInventory.IsActive, ItemInventory.SalesDesc, ItemInventory.SalesPrice, ItemInventory.QuantityOnHand, ItemInventory.QuantityOnSalesOrder
FROM ItemInventory ItemInventory
WHERE (ItemInventory.QuantityOnHand>0)
ORDER BY ItemInventory.FullName

Sure, just use the NOSYNC tag like this:

SELECT ItemInventory.FullName, ItemInventory.IsActive, ItemInventory.SalesDesc, ItemInventory.SalesPrice, ItemInventory.QuantityOnHand, ItemInventory.QuantityOnSalesOrder
FROM ItemInventory NOSYNC WHERE (ItemInventory.QuantityOnHand>0)
ORDER BY ItemInventory.FullName

See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more info.

I tried this and it doesn't seem to make a difference.  Maybe I'm misunderstanding the two passes.  The first one (41 sec), I see a rapid count up to my 15000 records (records found), the second one (pass) is the long one and I don't see the same record count (records found 0...)

Here's the change I made per your suggestion

SELECT ItemInventory.FullName, ItemInventory.IsActive, ItemInventory.SalesDesc, ItemInventory.SalesPrice, ItemInventory.QuantityOnHand, ItemInventory.QuantityOnSalesOrder
FROM ItemInventory NOSYNC
WHERE (ItemInventory.QuantityOnHand>0)
ORDER BY ItemInventory.FullName

Any other ideas?