you are viewing a single comment's thread
view the rest of the comments
[–] 29 points 2 years ago (14 children)

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

  • source
  • hideshow 14 child comments
  • [–] 29 points 2 years ago* (1 child)

    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

  • source
  • parent
  • hideshow 1 child comment
  • [–] 17 points 2 years ago (6 children)

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

  • source
  • parent
  • hideshow 6 child comments
  • [–] 10 points 2 years ago (5 children)

    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.

  • source
  • parent
  • hideshow 5 child comments
  • [–] 1 point 2 years ago (4 children)

    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?

  • source
  • parent
  • hideshow 4 child comments
  • [–] 5 points 2 years 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.

  • source
  • parent
  • [–] 15 points 2 years ago (4 children)

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

  • source
  • parent
  • hideshow 4 child comments