Why on earth can’t Excel handle 2 files with the same name? [closed]

Microsoft say here it’s due to calculation ambiguity with linked cells.

If you had a cell=”[Book1.xlsx]Sheet1″!$G$33 and you had two books
named ‘Book1’ open, there’s no way to tell which one you mean.

This way of referring to linked workbooks by name in cells persists through all versions, and I doubt very much it will change.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)