• Eheran@lemmy.world
    link
    fedilink
    English
    arrow-up
    11
    ·
    edit-2
    1 year ago

    Excel: taking ages to load a file

    Excel: There is a link to another Excel document, but I can’t access it to update the value.

    Me: Where?

    Excel: To this document.

    Me: … Where can I find the cell that contains this link?

    Excel: I don’t know noises

    Me: What if it is a named variable?

    Excel: Yes.

    • Saneless@lemmy.world
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

      And don’t even try to do a conversion of text to numbers in a big column. There’s a super fast way (name is eluding me) but if you respond to the error popup I imagine it looks at each cell of text, thinks says, “abracadabra you’re now a number!” for every row. It takes that long