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

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!