Refresh button on Analyse Tab

[KingFriday]

Hello to all. I've been studying Excel for about a week so please keep that in mind!

I understand the "Refresh" button is for updating the Pivot Table Cache when the Source Data has changed.

Someone told me that is will also update the changes made by others on a Co-Authored spreadsheet but this did not prove to be the case.

The sheet was open on my Excel and on the OneDrive site which was accessed from an email address of mine that is not my Microsoft account OneDrive.

Should this have worked?

Thanks in advance! KF

 

[KingFriday]

Bump