"refresh all" doesn't refresh all pivot tables at once

%3CLINGO-SUB%20id%3D%22lingo-sub-2062868%22%20slang%3D%22en-US%22%3E%22refresh%20all%22%20doesn't%20refresh%20all%20pivot%20tables%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2062868%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei'm%20having%20an%20issue%20since%20this%20morning%20and%20was%20hoping%20you%20could%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20i%20hit%20refresh%20all%2C%20i%20noticed%20that%20not%20all%20the%20pivot%20table%20refreshes%20(it%20used%20to%20work%20great).%20I%20have%20to%20press%20refresh%20all%20a%20second%20time%20to%20refresh%20the%20remaining%20pivot%20table.%20What%20i'm%20scared%20is%20that%20some%20pivot%20tables%20may%20still%20not%20refreshed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20additional%20information%3C%2FP%3E%3CP%3E-%20It's%20doing%20this%20across%20all%20my%20files.%20I%20even%20downloaded%20backup%20files%20from%20september%20and%20the%20problem%20occurs.%3C%2FP%3E%3CP%3E-%20my%20files%20do%20not%20have%20connections.%20All%20the%20data%20is%20local%2C%20within%20the%20files%3C%2FP%3E%3CP%3E-%20%22automatic%22%20calculation%20is%20activated%20(i%20checked%20for%20every%20single%20pivot%20tables)%3C%2FP%3E%3CP%3E-%20I%20uninstalled%20excel%20and%20installed%20it%20again.%20Issue%20still%20occurs.%3C%2FP%3E%3CP%3E-%20I%20tried%20recreating%20some%20of%20the%20pivot%20tables%2C%20the%20issue%20still%20occurs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20what%20it%20might%20be%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20the%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2062868%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi all,

 

i'm having an issue since this morning and was hoping you could help me.

 

When i hit refresh all, i noticed that not all the pivot table refreshes (it used to work great). I have to press refresh all a second time to refresh the remaining pivot table. What i'm scared is that some pivot tables may still not refreshed.

 

Some additional information

- It's doing this across all my files. I even downloaded backup files from september and the problem occurs.

- my files do not have connections. All the data is local, within the files

- "automatic" calculation is activated (i checked for every single pivot tables)

- I uninstalled excel and installed it again. Issue still occurs.

- I tried recreating some of the pivot tables, the issue still occurs.

 

Any idea what it might be?

 

thanks for the help!

 

 

 

0 Replies