We have an Excel file with a pivot and a data tab. It is stored on the server, and when the user downloads it, a process fills the data tab and changes the pivot's data source to the newly added data. Because of this, I selected the Refresh data when opening the file option option, and when I open the file, after clicking the Enable editing button, the pivot refreshes and contains the correct data.
However, for some other users it does not work. They hit the Enable editing, but the pivot stays empty. If they directly Refresh the data in the pivot, the data appears (so no links or names are broken). Also, if they send the same document to someone else, the data appears on opening the file.
My guess is that some local setting on their computer or in their Excel (Microsoft 365 for business) prevents the data from loading, but I have no idea where to start looking. What can cause this issue on their computer?