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
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…
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.
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.
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
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
Lool
You also can’t open two spreadsheets that have the same filename. I’m sure that’s led to a helpdesk call or two.
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.
It’s to do with the ability to work with data across all open workbooks:
You can reference
[Workbook.xlsx]Sheet1!B2but if you have two excel workbooks open, both namedWorkbook.xlsxwhich one should be used?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.
So throw an error at runtime on that macro, most workbooks aren’t the target of a macro
Whichever one has the smallest relative path to the workbook using it? How does it find the workbook if it isn’t open already?
It doesn’t.
“Hello, yes, IT department? I think my co-worker’s keyboard is missing all their punctuation marks. Yes, it’s making communication very difficult.”
“microsoft powerpoint excel”
Here is an alternative Piped link(s):
microsoft powerpoint excel
Piped is a privacy-respecting open-source alternative frontend to YouTube.
I’m open-source; check me out at GitHub.
Apologies dyslexia
Funny that they managed to spell “don’t” and “couldn’t” correctly.