• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel data source slow

Ramz21

New Member
I have connected SQL Server and Excel as data source and created pivots.

But the data refresh rate is very slow. All the devices are on the same network and same domain.

I am using SQL Server 2008 and Excel 2007.

For few views the data refreshes faster and for few view the refresh rate is very slow.

Is there any way where can increase the refresh speed ?

Regards,
Ram
 
Hi Ram ,

If a network is involved , it is difficult to say whether the network is the culprit.

If you can move all the files involved to the same computer , you can test and decide conclusively whether it is the software which is at fault or it is the network which is at fault.

Narayan
 
Hi Narayan,

I have tested that as well, the situation remains the same. Might be a slight variation of milli secs and apart from that rest all seems to be same in both the scenarios.

Regards,
Ram
 
Back
Top