Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Prevent error message "External Data Refresh Failed Close We were unable to refresh one or more data connections in this workbook" from showing (Excel 365)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I keep getting the following error when opening my Excel 365 workbook:
"External Data Refresh Failed Close We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh: ..."
This workbook has 3 sheets --2 of them synchronized with 2 other Excel 365 workbooks (I had to do this because these are linked to Forms, and Excel only allows you to link 1 form per workbook).
Since this is a shared document, I would like to prevent this error message from showing -is there any way to either stop this message from showing or sync the other 2 workbooks in a way that we don't have this issue?
Thanks!
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.