Forum Discussion
Linking Active Workbook to Closed Workbook
This seems to be a topic that no one has a good answer for unless you're the only person working on the file from one device which in 2024 is unlikely. I have seen loads of other posts bringing this ...
If you place your list of contacts in a table and then create a range name that points to all cells in the table, you can use a direct reference to the range name (easiest while both files are open) in the hidden worksheet, similar to this:
=[file with contacts.xlsx]!YourNewRangeName
In my experience, as soon as the workbook containing this formula is saved outside of the folder structure, the link becomes absolute and should keep working, provided the user has read-rights to that location (and a working connection). Now all it should take is editing the file with contacts.
Of course the user must update links when using the file.
=[file with contacts.xlsx]!YourNewRangeName
In my experience, as soon as the workbook containing this formula is saved outside of the folder structure, the link becomes absolute and should keep working, provided the user has read-rights to that location (and a working connection). Now all it should take is editing the file with contacts.
Of course the user must update links when using the file.
JKPieterse I agree on the range and had indeed understood that that is how he works. But I think you find that you are wrong. Do not open the foreign Workbook with that range and the referencing Workbook sees #REF!. Which is why I open all linked Workbooks from Auto_Open.
Jn12345 You seem to be struggling with succession handling which is never easy. Also a big minefield in TEAMS. A natural Person must be assigned a Role. That Role can then be assigned to Tasks. That way, when the Person leaves the company, a new Person can be assigned to the Role and all Tasks should automatically then show the new Person.