Forum Discussion

HazelTS's avatar
HazelTS
Copper Contributor
Mar 12, 2024

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

Excel online shows the image     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. 
Excel for web
mathetes's avatar
mathetes
Silver Contributor
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?
HazelTS's avatar
HazelTS
Copper Contributor
Mar 12, 2024

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.

  • mathetes's avatar
    mathetes
    Silver Contributor
    Mar 12, 2024
    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.
  • HLD1234's avatar
    HLD1234
    Copper Contributor
    Mar 22, 2024

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

    Thanks!

    • HazelTS's avatar
      HazelTS
      Copper Contributor
      Mar 23, 2024

      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.

Resources