Pivot Table Timeout

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

We have a pivottable control embedded in an html file. The pivottable control requests data from a SQL Server.

It works fine unless the query that is selected takes longer than 30 seconds to complete. At that point, a message box appears stating, "Timeout expired".

I have tried eveything that I can think of to work around this limitation. Is there a known workaround or patch for this?

Thanks!

Replies accepted here or:
danhvos (at) comcast.net

.