asked on

pivot table refresh not working in IE, but working in Firefox.

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!

ASKER CERTIFIED SOLUTION

wellous

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

heyday2004

ASKER

I did have this on the IE browser.

Here is what I found but I dont know why:
In IE, the file opened is saved in cache with some [] on the name, say, it could be saved as:
document[1].xls And this causes problem. I could repeat this in my local desktop:
1. for the same file with Pivot table: document.xls, when I renamed it with docuemtn[1].xls, when I refresh it, I will get errors (reference is not valid).But when I revised the name by removing [] sign, say, document.xls, I don't have any issue in refresh the pivot table data source. In Firefox, I guess the files in the cache don't have []?

Thanks for any further hint.

SOLUTION

wellous

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

heyday2004

ASKER

Thanks, here is what I did (i'm new to Macro):
i pressed alt+F11 and entered the above content and saved the excel file. and when I opened the excel file, I got a warning: Macro is disabled, when I enabled it, I still got the reference is not valid error. How did you revise it to make it work? Thanks!

SOLUTION

wellous

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

heyday2004

ASKER

Thanks a lot. Seems it requires users to enable Macros? I might have permission problem to enalbe Macro? Any other solutions that don't require security setting changes? Thanks.

SOLUTION

wellous

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

wellous

thanks for the grade :)
Wellous