Hi,
the refresh all button on the data ribbon tab is not working at all and also the refresh button.
also when i right click the pivot table the refresh is not working too.
when I refresh the file through vba command it is working.
any idea how to fix it?
I am using excel 2016 professional version 32 bit - windows 7.
it happened when they switch my comuter to new one in work.
Thank you for the help