• Destide@feddit.uk
    link
    fedilink
    English
    arrow-up
    29
    ·
    7 months ago

    Had a call to sort an issue where someone couldn’t open an excel file because they already had it open don’t know why that needed a warning over a simple window switch to the sheet they wanted but hey stopped me doing what I was doing for nothing

    • Rentlar@lemmy.ca
      link
      fedilink
      arrow-up
      30
      arrow-down
      1
      ·
      edit-2
      7 months ago

      Yeah, needing to use Microsoft Office for everything at work is a damn pain. This one time I am trying to close Word, but then I must have clicked the top right X one too many times so the “You can’t close Word until the Closing… dialog is dismissed” dialog pops up, which itself interrupts the Closing dialog…

      Screen photo

    • ubergeek77A
      link
      fedilink
      arrow-up
      17
      ·
      7 months ago

      You also can’t open two spreadsheets that have the same filename. I’m sure that’s led to a helpdesk call or two.

      • Buddahriffic@lemmy.world
        link
        fedilink
        arrow-up
        10
        ·
        7 months ago

        I lost a lot of respect for Microsoft when I first saw that issue. It’s such an easy to avoid limitation. Like probably a similar level of difficulty to remove that limitation than to write the error message explaining it, unless it’s more of a spaghetti mess than I’m expecting it to be.

        • KairuByte@lemmy.dbzer0.com
          link
          fedilink
          arrow-up
          1
          ·
          7 months ago

          It’s to do with the ability to work with data across all open workbooks:

          You can reference [Workbook.xlsx]Sheet1!B2 but if you have two excel workbooks open, both named Workbook.xlsx which one should be used?

          • Buddahriffic@lemmy.world
            link
            fedilink
            arrow-up
            5
            ·
            edit-2
            7 months ago

            If you want to reference other files, you should use a less ambiguous way to refer to them. Like a relative path or full absolute path. The fact that that weakness is because of a half-baked feature like that actually makes me lose even more respect.

            Edit: thanks for the info though, it does add some missing context.

          • Morphit @feddit.uk
            link
            fedilink
            arrow-up
            3
            ·
            7 months ago

            Whichever one has the smallest relative path to the workbook using it? How does it find the workbook if it isn’t open already?

          • psud@lemmy.world
            link
            fedilink
            arrow-up
            3
            ·
            7 months ago

            So throw an error at runtime on that macro, most workbooks aren’t the target of a macro

    • Liz@midwest.social
      link
      fedilink
      English
      arrow-up
      15
      ·
      7 months ago

      “Hello, yes, IT department? I think my co-worker’s keyboard is missing all their punctuation marks. Yes, it’s making communication very difficult.”