Forum Discussion

Mfriz's avatar
Mfriz
Copper Contributor
Mar 18, 2024

Using Image Function but Print Preview is #Unknown

Hello I'm a Microsoft Newbie,

I first used Google Docs to setup images through links but when making the switch to Microsoft I can't get Images to print, it just would have it state #unknown in the print preview. Insert image isn't going to be a good alternative because I have hundreds of images I would work with and it seems to be having similar problem. 

I'm currently using Microsoft 365 Excel Web Version. The first row is using a insert image method, the rest are with the =IMAGE() function. Any direction as to why this might be happening would be greatly appreciated.

Thank You!

 

In Print PreviewIn Excel spreadsheet

 

excel
Excel for web
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Mar 18, 2024

    Mfriz 

     

    Insert a picture in Excel for the web

    The IMAGE function in Excel for the web has some limitations compared to the desktop version, and one of these limitations may be causing the #UNKNOWN error in the print preview.

    Here are a few potential reasons why you might be encountering this issue:

    1. Unsupported Image Formats: The IMAGE function in Excel for the web may not support all image formats. Make sure that the images you're trying to insert are in a supported format such as JPEG, PNG, GIF, or BMP.
    2. Image URLs: Ensure that the URLs you're using in the IMAGE function are valid and accessible. If the URLs are incorrect or the images are hosted on a private server, they may not display properly.
    3. Permissions: Check the permissions of the files or URLs you're trying to insert. If the images are hosted on a server that requires authentication or permission to access, they may not be visible in Excel for the web.
    4. Excel Version: While Excel for the web continues to improve with each update, it may not support all features available in the desktop version. Consider using the desktop version of Excel if the IMAGE function is essential for your workflow and the web version is not meeting your needs.
    5. Browser Compatibility: Ensure that you're using a supported browser for Excel for the web and that it is up to date. Some features may not work as expected in older or unsupported browsers.

    If none of the above solutions resolve the issue, you may need to consider alternative methods for inserting and displaying images in Excel for the web, such as using the insert image feature or embedding images directly into the spreadsheet. Alternatively, you could search the upper links.

    IMAGE function

    How it works with example file

    The text was created with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.