I have put a Excel pivot table on a web server which is link up with MSSQL. Let users to view all the latest data on MSSQL. However, I found the pivot table did not refresh and update when it is opened on Internet Explorer. Though I set the table auto refresh when it is opened. It did not work at all. Could any one point me out how to solve this problem. Thanks a lot.