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
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