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. 

  • 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

      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
        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.
  • lbaystate's avatar
    lbaystate
    Copper Contributor

    Have you figured out a solution?  We use excel because it does not change the settings - margins, size, etc.  I will have to play with word. HazelTS 

    • HazelTS's avatar
      HazelTS
      Copper Contributor

      lbaystate No but I upgraded my version of office and now I have the pictures loading directly in Excel, I don't have to go to excel online.

       

      This has created a different problem as the tabs with the formulas generating images are so slow to load - I don't know if there's a way of switching off the hyperlinks. But anyway my reports were already designed and written so luckily it's ok!

      • lbaystate's avatar
        lbaystate
        Copper Contributor
        That's what I thought. The point of having it online is so we can access it anywhere and share it. That stinks. It was working too for us before and then it stopped.

Resources