I am dealing with two spreadsheets. Spreadsheet A has has references and
links to cells on Spreadsheet B. Both of these spreadsheets are password
protected. When I open Spreadsheet A, I am prompted for my password. I'm
then asked if I want to update my links. If I respond yes, I'm prompted for
my password and Excel opens Spreadsheet B.
I've got several spreadsheets that fit this scenario, but this is the only
one that tries to open the linked spreadsheet.
How can I prevent Spreadsheet B from opening everytime I update Spreadsheet A?