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?


According to the official article "Refresh an external data connection in Excel":

Connections to external data may be currently disabled on your computer. To refresh the data when you open a workbook, you must enable the data connections by using the Trust Center bar, or you must place the workbook in a trusted location. For more information, see Add, remove, or modify a trusted location for your files, Add, remove, or view a trusted publisher, and View my options and settings in the Trust Center.

For more information about external content in Office documents, read Block or unblock external content in Office documents.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.