Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links
I have a worksheet which has links to another workbook.
When I copy these links with code, something happens which I do not understand. I am using Copy - Pastespecial to copy the cells containing the links. When the links are to files in the same directory as the workbook, the links are copied but them take an age to refresh, before the next column of links are copied and so on. When the links are to workbooks in a different directory, the links are copied, but then a model dialog box appears asking where the linked file is. If I click Cancel the code proceeds and when the workbooks recalculates all the links are correct. Can anyone explain this and tell me how I can avoid my code being stopped and a user input required? PWS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |