KairuByte , vor 2 Monaten 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?
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?
[Workbook.xlsx]Sheet1!B2
Workbook.xlsx