How to get password prompt again without closing and re-opening workbook

[Monimonika]

I have several formulas in my workbook that reference a separate password-protected workbook.
When I open my workbook, I am prompted for the password for those references, but sometimes I mistype and the prompt closes.

Is there a non-VBA way to get the password prompt to show up again after a mistyped password closes the password prompt? I would rather not have to close my workbook and re-open it just to get the prompt back.

[tim201110]

i'd rather use this:
http://www.ozgrid.com/forum/showthread.php?t=79784

[Monimonika]

Thank you for the link, but I actually need to edit my workbook. So, opening in read-only is not an option.

I've tried clicking on and recalculating one of my formulas that references the other password-protected workbook, which brings the password prompt back up. However, entering the password only works for that one cell and leaves the formulas in other cells uncalculated.

[Monimonika]

I've figured out the obvious. I just need to go to Data -> Edit Links and update the values for links to the password-protected workbook. Password prompt comes up, all links are updated. Me was not smart.