Forum Discussion
IMAGE function throws #CONNECT error for photos on Sharepoint
The spreadsheet I'm working in uses the IMAGE function to display photos that are on our company's Sharepoint, however sometimes when I open the sheet the function returns a #CONNECT error. I've foun...
The following article seems to have helped, deleting the Office Cache might be the solution until the problem is fixed: https://learn.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache
Edit: I've found that clicking "Refresh All" under the Data tab is more reliable and significantly easier.