Queries are extracting between 30 lines of data up to 4,000 for only one query.
Excel Workbook Takes Long Time To Update The SameNow there is inconsistency and it can take up to 5 minutes to update the same amount of data with about the same queries.![]() There were some minor changes to some queries, but reversing the changes does not get the workbook back to its normal speed. Even deleting all the queries except one still left the workbook extremely slow. It looks like Microsoft Query has to be opened and connected to the database on a an Excel workbook opening to have a decent speed. You need to run the queries directly in a tool like SQL Server Management Studio and see how it takes. Jules - I monitored the run time and it doesnt seem to be the problem as the workbook can be very fast sometimes. The workbook is sometimes fast if I create a new blank workbook while the dashboard is open and that I create a new query with microsoft query. The workbook will be fast half of the times if after seeing the connection statement from Microsoft query. Thats not very an option for the moment as the problem is inconsistent. It is all about the connection string to the server and named pipes. It was taking about 15 seconds to make the connection and now it is near instantaneous. Provide details and share your research But avoid Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. Not the answer youre looking for Browse other questions tagged sql-server excel vba or ask your own question.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |