Before you troubleshoot anything, you need to know which feature you’re actually using — because there are two, they behave completely differently, and almost every confused forum thread on this subject is caused by people mixing them up.
The first is Place in Cell: a menu command that takes a picture from your device and embeds it inside a cell, so the image becomes the cell’s value rather than a floating object sitting on top of the grid. The second is the IMAGE function, a formula — =IMAGE("https://…") — that pulls a picture from a web URL into a cell. They share an outcome (a picture living in a cell) and nothing else. The version requirements differ, the failure modes differ, and the fixes differ. If you skip this distinction, you will spend an afternoon applying the wrong fix to the wrong feature.
So let’s take them one at a time.
Place in Cell: why the option is missing or greyed out
This is the most common complaint, and the honest answer is that Microsoft made it confusing on purpose by rolling the feature out unevenly. Here are the real causes, in the order you should check them.
You’re not on a version that has it. Place in Cell requires Microsoft 365 or Office LTSC 2024. It is not in Excel 2019 or Excel 2021, and it never will be — perpetual-licence versions only get the features that existed at the time you bought them, plus security patches. For perpetual builds, the feature also depends on the build number (roughly 16529 or later). The catch is that “Version 16.0” appears on everything from Excel 2016 onward, so checking the version number alone tells you nothing. Go to File → Account → About Excel and read the full build string, not just the marketing version.
The cursor is active in the cell. This one catches people constantly and it’s almost insulting how simple it is. If you’ve double-clicked into a cell so the text cursor is blinking inside it, Place in Cell greys out. Press Escape, then select the cell with a single click, and the option comes back.
You’re on a rolling-release install that simply hasn’t received it yet. Microsoft 365 features deploy to subsets of users over weeks. There are documented cases of two machines running what looks like the identical Excel version, where one has Place in Cell and the other doesn’t. This is maddening and there is no clever fix — update to the latest build (File → Account → Update Options → Update Now) and, if it’s still absent, wait. It usually appears within a few weeks.
Connected experiences are disabled by your IT admin. On corporate machines, administrators can switch off the “connected experiences” that several modern Excel image features depend on. If you’re on a locked-down work laptop and the feature is missing where it should exist, this is the likely culprit — and it’s not something you can fix yourself. Raise it with IT.
You’re on Excel for Mac. The Mac version frequently hides the ribbon button even when the underlying feature works. The workaround: insert the picture as a floating image the old way, then right-click it and choose Place in Cell from the context menu. The same trick works on Windows when the ribbon path is missing but the feature is present — insert floating, right-click, Place in Cell.
That last workaround is worth internalising because it’s the single most reliable fallback across the whole feature. If the ribbon won’t cooperate, the context menu often will.
IMAGE function errors: decoding what Excel tells you
The IMAGE function fails differently. Instead of a greyed-out menu, you get an error value in the cell, and Excel is actually fairly informative about which one you’re seeing.
#BLOCKED! — This is the one almost everyone hits first, and it isn’t a real failure. The first time you use IMAGE in a workbook, Excel blocks the external content for security and shows a notification bar at the top of the screen asking you to enable it. Click Enable, and the images load. You only do this once per workbook. If you’re on Excel for the web or mobile and the bar doesn’t appear, check the security settings for Linked Data Types — the same block applies but the prompt is in a different place.
#CONNECT! — The function is fine; your connection to the image source isn’t. Either your internet is down, or the server hosting the image isn’t responding. Check the URL works in a browser. If it loads there but not in Excel, the host may be blocking Excel’s request specifically.
The image won’t load and there’s no error — Two usual suspects. First, the URL must be HTTPS, not HTTP. Excel silently refuses plain HTTP links. Second, the URL has a hard limit of 255 characters, and browser address bars routinely produce longer ones. Don’t copy the address bar — right-click the image in your browser, choose Copy image link (or “Copy image address”), paste that into a spare cell, and reference the cell: =IMAGE(A1). This sidesteps both the length limit and a surprising number of malformed-URL problems.
You tried to point IMAGE at a local file — It won’t work, and people waste real time on this. =IMAGE("file:///C:/…") does not function, even though the same path opens in Edge. The IMAGE function only takes web-hosted images over HTTPS. If your picture is on your hard drive, you want Place in Cell, not IMAGE. (This is exactly the kind of cross-wiring the two-features distinction at the top of this article is meant to prevent.)
What’s actually supported
Microsoft’s documentation is vague here, so here’s the practical version.
Place in Cell works with standard local image files and is available on M365 and LTSC 2024 across Windows, Mac, and the web.
The IMAGE function is M365-only and runs on Windows, Mac, the web, Android, and iOS. Supported formats are BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP — with one trap: WEBP does not work in Excel for the web or on Android, only on the desktop apps. And SVG is not supported at all, which is a genuinely annoying omission given SVG is the format Microsoft’s own Office icons ship in. If you have an SVG you need in a cell, convert it to PNG first.
The IMAGE function also takes an optional sizing argument that controls how the picture fits: 0 fits the image to the cell keeping its aspect ratio (the default), 1 fills the cell and ignores aspect ratio (so it may distort), 2 keeps the original size even if it overflows the cell, and 3 lets you set an exact height and width in pixels. If your in-cell images look stretched, you almost certainly have sizing set to 1 when you wanted 0.
The “fix” that wastes your time
The most common bad advice circulating is “add the button via Customize Ribbon.” You’ll see people earnestly explaining that you go to File → Options → Customize Ribbon and add the command. This does nothing for Place in Cell, because the option being greyed out or absent is a version and licensing condition, not a missing ribbon button. You cannot add a feature your build doesn’t contain by rearranging the ribbon. If the cause is version, connected experiences, or staged rollout, ribbon customisation is a dead end — go back to the checklist above.
Which one should you actually use?
If your images live on your device and you want them embedded permanently in the file, use Place in Cell. The pictures travel with the workbook, they don’t depend on a live internet connection, and — importantly — they move and sort with your data automatically because they are the cell value. This is the feature most people should be using, and it quietly solves the perennial problem of images not moving with cells when you filter or sort.
If your images live on a web server and you want them to update when the source changes — a product catalogue pulling from a CDN, say — use the IMAGE function. Just accept the dependencies: HTTPS, a live connection, and no SVG.
What you should stop doing is the old approach of dropping floating pictures over the grid and then wrestling with anchor settings to make them behave. That method still works, and sometimes you have no choice, but if you’re on a version with Place in Cell, the floating-picture era is over. Use the feature built to replace it.
If you suspect what you’re hitting is a regression rather than a configuration issue — the feature worked last week and broke after an update — check the Microsoft Office Image Regression Timeline to see whether your build is a known offender before you spend any more time on it. And if your in-cell images look fine on screen but vanish from printouts, that’s a separate setting entirely, covered in images not printing with the sheet.