I have a workbook which links to over 100 other workbooks. I recently
upgraded to office 2007, and when I try to edit the links, the dialog box
doesn't fit on the screen and so I can't edit all the links in my workbook.

Is this just a bug, or does anyone know of a workaround?

Thanks

I put the Edit, Link dialogs of Excel 2007 and 2003 next to each other and
they are virtually identical with only the smallest cosmetic differences.
Of course I don't have a workbook with links to 100 others so I couldn't
duplicate your scenario. I did set up an example with 8 links or so, more
than enough to fill the listbox, and I found I could scroll to all of them.

--
Jim
"malcomio" wrote in message
...
|I have a workbook which links to over 100 other workbooks. I recently
| upgraded to office 2007, and when I try to edit the links, the dialog box
| doesn't fit on the screen and so I can't edit all the links in my
workbook.
|
| Is this just a bug, or does anyone know of a workaround?
|
| Thanks

Thanks Jim. The dialog box does look very similar, the only problem is that I
can't resize it, and it's too big for my monitor. I can just about get around
the problem by sorting the list by different criteria, but it's not ideal.