Hello,
I've a problem concerning SQL data queries in Excel 2007. I've an Excel file for financial reporting and in this file there are hundreds of SQL queries into SQL Server database (using external data connection into named ranges). Each named range in one SQL query into MS SQL Server database.
Everything works just fine except that I've high CPU utilization (75-98%) even if I don't refresh the data. So even if I only open the Excel for viewing I've high CPU utilization. Is it because of these hundreds of connections? Is there any way how to improve the utilization?
Thank in advance for any answer.
Regards
Lukas Pitka