this post was submitted on 20 Apr 2024
974 points (97.1% liked)
linuxmemes
20707 readers
838 users here now
I use Arch btw
Sister communities:
- LemmyMemes: Memes
- LemmyShitpost: Anything and everything goes.
- RISA: Star Trek memes and shitposts
Community rules
- Follow the site-wide rules and code of conduct
- Be civil
- Post Linux-related content
- No recent reposts
Please report posts and comments that break these rules!
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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!B2
but if you have two excel workbooks open, both namedWorkbook.xlsx
which one should be used?So throw an error at runtime on that macro, most workbooks aren't the target of a macro