Forum Discussion
=Image returns a #connect error
Hi All, I'm experimenting with the new =Image function, and somehow I can't get it to work. I copied a file to my sharepoint site, set the permissions to "anyone can view". I copied the URL and paste...
This worked for me:
- Open the spreadsheet from which you want to access the pictures using the IMAGE function and create an empty sheet
- Go to the sharepoint site and find the folder where the images are hosted
- Export the list of files to excel using the sharepoint menu
- After opening the .IQY file, it's gonna ask where you want to download the data to. Select "existing sheet" or something like that, and select a cell in the empty sheet you created before.
From now on, this Excel file will be able to access the SharePoint site you queried with the .IQY file because you literally created a connection to SharePoint from within the excel workbook.
