asked on Pivot table in excel 2007 not updating automatically
Hi,
I have a pivot table in an excel 2007 file set to “Refresh data when opening the file”
However when I open the file I have to Refresh the Pivot table manually.
Any ideas how I can get this option to work ?
thanks
I have a pivot table in an excel 2007 file set to “Refresh data when opening the file”
However when I open the file I have to Refresh the Pivot table manually.
Any ideas how I can get this option to work ?
thanks
Microsoft Excel
Last Comment
blossompark
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
jppinto
will try your suggestion...once i figure out how to add the code!!
will try your suggestion...once i figure out how to add the code!!
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
hi rorya...just data on a sheet
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
just one other piece of information... they're are other tabs in the file that have pivot tables that are updating fine...it is just this one that needs to be manually updated
ASKER
Hi sanjithml, ippinto, David, rorya , matthewspatrick
I have populated the column that the pivot references with dummy data and now it is updating when opening...
the excel file i am using is a template that gets xml data dumped into it ...
it now seems to be working ok..
thanks for all your inputs, greatly informative and appreciated :-)
I have populated the column that the pivot references with dummy data and now it is updating when opening...
the excel file i am using is a template that gets xml data dumped into it ...
it now seems to be working ok..
thanks for all your inputs, greatly informative and appreciated :-)
Oh...and i thought all i had to do was tick the box
updating manually
produces the results
roryo...it links directly to a range on another tab