Pivot table data won't auto refresh

%3CLINGO-SUB%20id%3D%22lingo-sub-2323503%22%20slang%3D%22en-US%22%3EPivot%20table%20data%20won't%20auto%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323503%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pivot%20table%20that%20won't%20refresh%20the%20data%20when%20the%20file%20is%20opened.%20In%20Pivot%20Table%20Options%20the%20%22Refresh%20data%20when%20opening%20the%20file%22%20is%20checked.%26nbsp%3B%20Sometime%20I%20go%20to%20make%20sure%20the%20box%20is%20checked%20and%20it's%20unchecked%20again.%20Is%20there%20a%20security%20setting%20that%20causes%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2323503%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a pivot table that won't refresh the data when the file is opened. In Pivot Table Options the "Refresh data when opening the file" is checked.  Sometime I go to make sure the box is checked and it's unchecked again. Is there a security setting that causes this issue?

0 Replies