I have just had 2 responses from Microsoft on this issue:
<<
Thank you for the bug report. This is a known issue, recorded in the
current product database under the title 'Height of "Edit Links" dialog
can exceed screen height with many links in book'

I commented that bug and also notified several others involved in this
area that we've had an MVP report of this as well.

Thanks again for the bug report.
Posted by Microsoft on 09/01/2008 at 20:05

<<
Also, some potential workarounds to consider:
- Use the VBA object model (.ChangeLink, .BreakLink), etc., to edit
individual links.
- With a link selected, press the down arrow key to scroll through the
links, including those not visible. Selecting Change Source will allow
you to see which link you're on, and hotkeys - for example, Alt+s for
Startup Prompt - can be used for the dialog controls that are not
visible.
- To see the rest of the dialog, while the Edit Links dialog is
displayed, press Alt+spacebar, M, then use arrow keys to move dialog.

Admittedly, some of these are not practical with a very large number of
links, but perhaps one of these may prove helpful.
Posted by Microsoft on 09/01/2008 at 21:13


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup