When I download an excel file with Pivot table from the html link in IE, I have data refresh issue (or Reference is not Valid issue). But I don't have problem in Firefox:
When I clicked the download, the browser will ask me "do you want to open or save this file", I choose open it directly, and the file is downloaded to the temp folder, and then I see the pivot table is blank. The refreshing doesn't work (I've selected the Pivot table option: Refresh data when opening the file).
But in Firefox, when I open it, the Pivot table is refreshed and everything is ok.
And even for IE, when I choose save as option to save it to desktop, then open it, everything is good too.
The only thing is when I open an excel file in IE, I will have refreshing not working issue for Pivot Table (no data shown in IE pages)
Any hint is appreciated. Thanks!