Excel 2016.
I have cells in a book linked to another book.
Seems the destination book isn't keeping up.When I open the book, do I need to answer "yes" to the question "do you want to update links?". Or better, how do I get that to just happen automatically?
Other thing is, if the destination book is not open while I am inserting rows into the source book, then brink up the destination book later, they lose track of each other. I think it's hopelessly broken at that point, right?
Ugh!
I have cells in a book linked to another book.
Seems the destination book isn't keeping up.When I open the book, do I need to answer "yes" to the question "do you want to update links?". Or better, how do I get that to just happen automatically?
Other thing is, if the destination book is not open while I am inserting rows into the source book, then brink up the destination book later, they lose track of each other. I think it's hopelessly broken at that point, right?
Ugh!
