Excel online displaying images but when I print - get Unknown! Errror

Copper Contributor

Excel online shows the image

 

Pics.png

But the print preview just shows an error? It has been working fine for a year and I haven't changed anything at all- just stopped working this week. 

Pics2.png

5 Replies
A simple question for you: why are you using Excel in this case? It would appear that you're creating a catalog of some sort, and while I'll grant that Excel's rows and columns layout is convenient for that, you can accomplish the same layout in Word (using Word's tables). So is there some other reason that draws you to Excel?

@mathetes it's a sell through report with figures that change weekly, I run it off Power BI - not sure how word would help this? The top sellers move positions which is why the images can't be fixed and have to be variable.

OK. So there's a reason; that's all I was asking. I've never used Power BI, so am not in a position to answer that.

@HazelTS I've been having the same issues and I'm curious if you ever found the solution? 

Thanks!

@HLD1234 I did not, sorry. However it turns out there is a newer version of Excel which I updated to, it will load pictures on the desktop version just like on sharepoint, and the print to pdf works fine from there. However this has created a new problem, in that I have a couple of hundred lines of pictures that now load every time I open the file in Excel, making the tabs that contain them extremely slow to load and scroll through. If I needed to modify them I think I'd have to mash the formula up temporarily just to get it all working! Sorry I can't be of help, I'm 90% sure it's a MS issue and I guess they just haven't seen it.