2013 Data Refresh issues

I've got several users who operate in a manufacturing environment. Two different users use this particular Excel file, which has SQL query set up to pull from a server. 

After setting up user A with a new workstation (Office 2013, windows 7, restarts & patched), his system takes approximately 20-30 seconds to perform a Data Refresh of a particular tab. It takes approximately this long for most Office 2013 installs to accomplish this that i've tested. This same function is accomplished in 1-2 seconds in office 2007 on any computer. 

I do have a user B who is on excel 2013, and the data refresh happens almost instantly. I've checked the trust center settings, options/advanced, and the file itself - I can't find any differences between his workstation and the others. I've tried disabling hardware acceleration, multi-thread calc, and some random other things without success.

Any suggestions for settings that could cause this? Below is the connection information.

Connection String: DRIVER=SQL Server;SERVER=vis-shop;UID=sa;PWD=XXXXXXXXX;APP=Microsoft Query;WSID=XXXX;DATABASE=vsdatabase

Command Text: 

SELECT DISTINCT ORDER_HEADER.customer_id, ORDER_LOAD.process_id, ORDER_PART.part_id, ORDER_LOAD.bc_order_load, ORDER_HEADER.entry_date, ORDER_HEADER.requested_date, ORDER_LOAD.ord_qty, ORDER_LOAD.shipped_qty, ORDER_HEADER.po_number, PROCESS_PART.price, PROCESS_PART.sq_inches, ORDER_PART.qty_per_ld, PROCESS_PART.price_min, PROCESS_PART.price_per, PROCESS_PART.pp_part_weight
FROM vsdatabase.dbo.ORDER_HEADER ORDER_HEADER, vsdatabase.dbo.ORDER_LOAD ORDER_LOAD, vsdatabase.dbo.ORDER_PART ORDER_PART, vsdatabase.dbo.ORDER_PROCESS_MASTER ORDER_PROCESS_MASTER, vsdatabase.dbo.PROCESS_PART PROCESS_PART
WHERE ORDER_HEADER.order_id = ORDER_LOAD.order_id AND ORDER_HEADER.order_id = ORDER_PART.order_id AND ORDER_HEADER.order_id = ORDER_PROCESS_MASTER.order_id AND ORDER_LOAD.order_id = ORDER_PART.order_id AND ORDER_LOAD.order_id = ORDER_PROCESS_MASTER.order_id AND ORDER_LOAD.load_id = ORDER_PART.load_id AND ORDER_LOAD.load_id = ORDER_PROCESS_MASTER.load_id AND ORDER_PART.order_id = ORDER_PROCESS_MASTER.order_id AND ORDER_PART.load_id = ORDER_PROCESS_MASTER.load_id AND ORDER_PART.seqno1 = PROCESS_PART.seqno AND ((ORDER_HEADER.order_status<>'D' And ORDER_HEADER.order_status<>'I' And ORDER_HEADER.order_status<>'S' And ORDER_HEADER.order_status<>'C') AND (ORDER_HEADER.customer_id>=? And ORDER_HEADER.customer_id<=?) AND (ORDER_HEADER.entry_date>={ts '1999-11-01 00:00:00'}) AND (ORDER_PROCESS_MASTER.process_id>=? And ORDER_PROCESS_MASTER.process_id<=?) AND (PROCESS_PART.cc>=? And PROCESS_PART.cc<=?))
ORDER BY ORDER_HEADER.customer_id, ORDER_LOAD.process_id, ORDER_PART.part_id
July 23rd, 2015 8:48am

No ideas?
Free Windows Admin Tool Kit Click here and download it now
July 27th, 2015 8:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics