Excel Error Codes

How to Fix the Excel IMAGE Function #CONNECT Error

Maira Mehtab Sep 22, 2026 872 views

Question details

The user needs to resolve a #CONNECT! error that occurs when using the IMAGE function in Excel with a SharePoint link.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Inserting an image into a spreadsheet cell using the IMAGE function and a provided URL.
Observed behavior: The IMAGE function returns a #CONNECT! error instead of rendering the picture, typically because the provided URL is a viewing or sharing link rather than a direct image file path.

Before you start

Verify that your computer has an active internet connection and that the target image URL is publicly accessible rather than restricted behind a login wall.

Solution 1Recommended

Use a Direct Image URL Instead of a Sharing Link

The #CONNECT! error primarily occurs when the formula is fed a web page or SharePoint viewing link instead of a direct file path. You must extract the direct image URL.

Excel's IMAGE function requires a direct path to the actual image file (ending in formats like .jpg or .png). A standard SharePoint sharing link opens a web page containing the image, which Excel cannot parse, resulting in a connection error.

Open the sharing link in your browser

Copy the SharePoint sharing URL or the problematic link and paste it into your web browser to open the image viewing page.

Copy the direct image address

Right-click directly on the loaded image in your browser and select 'Copy image address' or 'Copy image link' from the context menu.

Update the Excel formula

Return to your Excel spreadsheet and replace the old URL in your formula with the newly copied direct link, formatted as =IMAGE("https://example.com/image.jpg"). Press Enter.

Test the URL: You can verify the URL is a direct link by pasting it into a new browser tab. If it downloads the image or opens only the image without any website interface, it will work in Excel.

Solution 2

Clear Office and Browser Cache

If you are using a direct image URL and still receiving the error, clearing your cache can resolve background connection blocks.

Free Microsoft Office alternative

Easily Insert Images into Cells with WPS Office

If you are frustrated by Excel formula errors and restricted SharePoint connections, consider trying WPS Office. It provides a lightweight, highly compatible spreadsheet editor that allows you to easily embed local or web images directly into cells without struggling with complex URL formulas.

1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Excel workbook.
3. Insert Image to Cell: Navigate to the Insert tab, click Picture, and select 'Place in Cell' to easily embed an image without needing web URLs or formulas.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) ensuring seamless file migration.Insert pictures into cells directly from your local drive without encountering #CONNECT! errors.Lightweight software that launches quickly and runs smoothly on Windows, Mac, and Linux.Completely free to use with a clean, familiar interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel IMAGE function return a #CONNECT! error?

The #CONNECT! error indicates Excel is unable to establish a connection to fetch the image. This typically happens if the provided URL is a web page viewing link, requires a login, or does not point directly to an image file.

What image formats are supported by the Excel IMAGE function?

The IMAGE function supports standard web image formats including JPG, PNG, BMP, WEBP, and GIF. Ensure the direct URL you provide ends with one of these extensions.

Can I use the IMAGE function for local files on my computer?

No, the Excel IMAGE function currently only supports internet URLs that begin with 'https://'. To add images from your local hard drive, you should use the standard 'Insert Picture' feature instead.

Microsoft Office Error Codes