ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Edit links window (https://www.excelbanter.com/excel-discussion-misc-queries/143763-edit-links-window.html)

malcomio

Edit links window
 
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

Jim Rech

Edit links window
 
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



malcomio

Edit links window
 
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.


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com