Function Problems

How to Fix Excel IMAGE Function #BLOCKED or #VALUE! Errors

Olivia Miller Sep 25, 2026 875 views

Question details

The user is encountering #BLOCKED! and #VALUE! errors when using the Excel IMAGE function to insert pictures from external web links and Google Drive.

How to Fix Excel IMAGE Function #BLOCKED or #VALUE! Errors

Product: Excel
Device & OS: not provided
Scenario: Using the =IMAGE() formula to load and display images from external URLs, such as Google Drive links or standard web addresses.
Observed behavior: The formula returns a #BLOCKED! error when using an HTTP address and a #VALUE! error when using a Google Drive sharing link, instead of displaying the requested image.

Before you start

Verify that your computer has an active internet connection and that the image URLs you are trying to use are completely public and do not require a login.

Solution 1Recommended

Update the URL Protocol from HTTP to HTTPS

The IMAGE function strictly requires secure HTTPS links to load external resources. Using an insecure HTTP link will trigger a security restriction, resulting in a #BLOCKED! error.

Excel blocks insecure image downloads by default to protect your spreadsheet from malicious content. Updating the URL protocol is the fastest way to resolve this if the hosting server supports secure connections.

Locate the URL cell

Select the cell that contains the external image URL you are referencing in your IMAGE formula (for example, cell C1).

Edit the address

Click into the formula bar at the top of the workspace to edit the text of the URL.

Add HTTPS protocol

Change the beginning of the web address from 'http://' to 'https://' by adding the letter 's'.

Apply the change

Press Enter on your keyboard. The =IMAGE(C1) formula will automatically recalculate and display the image.

Protocol Update: If the host server supports HTTPS, adding the 's' will immediately resolve the #BLOCKED! error and render the image in your cell.

Solution 2

Use a Direct Image File URL Instead of a Webpage Link

Cloud storage sharing links, such as those from Google Drive, often point to an interactive viewing webpage rather than the raw image file itself, which causes the function to return a #VALUE! error.

Easily Insert Images into Cells with WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and user-friendly environment for managing data and images. You can seamlessly insert pictures directly into cells using built-in tools without dealing with complex URL restrictions or formula errors.

1. Open your workbook: Launch WPS Spreadsheet and open the document where you need to add images.
2. Select the target cell: Click on the specific cell where you want the image to be displayed.
3. Navigate to the Insert tab: Click on the 'Insert' tab located on the top ribbon menu, then click the 'Picture' button.
4. Choose Place in Cell: From the drop-down menu, select 'Place in Cell' to ensure the image automatically resizes to fit your selected cell's boundaries.
5. Select your image: Choose the image from your local device files or paste a valid network URL to insert it instantly without formula errors.

100% compatible with Microsoft Excel formats (.xlsx, .xls) and functionsBuilt-in 'Place in Cell' tool to insert images perfectly without formulasLightweight, fast, and free alternative to Microsoft OfficeEasily import local images or network pictures with a few clicks

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Google Drive link cause a #VALUE! error in the IMAGE function?

Google Drive standard sharing links direct users to a file viewer webpage rather than the raw image file. The IMAGE function cannot extract images from a webpage HTML layout, so it returns a #VALUE! error. You must use a direct download link or a hosting service that provides direct URL access to the actual image file.

What image file formats are supported by the IMAGE function?

The IMAGE function supports standard web image formats including BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP. Ensure your direct URL ends with one of these file extensions for the formula to work correctly.

Why do I still get a #BLOCKED! error even when using an HTTPS link?

A #BLOCKED! error with an HTTPS link usually occurs if the image requires authentication to view, such as a password-protected website or an internal company intranet server. The image URL must be completely public and accessible without any login credentials.

Excel & Data Problems