Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid the pop up message for updating links?
Does anyone have any suggestions on how to avoid the pop up message for
updating links? There is value 123 in cell A1 under file1.xls, and There is a cell in B1 under file2,xls, which connect to cell A1 from file1.xls. When I open file2.xls, it requests for updating link. I have specified for updating links, under Edit Links, that Excel always update links, and save it, when I open it next time, message, box is still pop up for confirmation. Do you have any suggestions on how to skip the confirmation on updating links? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid the pop up message for updating links?
Hi Eric
See: http://www.ozgrid.com/VBA/update-links.htm -- Regards Dave Hawley www.ozgrid.com "Eric" wrote in message ... Does anyone have any suggestions on how to avoid the pop up message for updating links? There is value 123 in cell A1 under file1.xls, and There is a cell in B1 under file2,xls, which connect to cell A1 from file1.xls. When I open file2.xls, it requests for updating link. I have specified for updating links, under Edit Links, that Excel always update links, and save it, when I open it next time, message, box is still pop up for confirmation. Do you have any suggestions on how to skip the confirmation on updating links? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to avoid opening alert message when click on hyperlinks? | Excel Discussion (Misc queries) | |||
How to Subtract times on 24hour clock and avoid error message in . | Excel Worksheet Functions | |||
how can i avoid an error message while printing an excel sheet | Excel Discussion (Misc queries) | |||
Can I avoid annoying Update Links message | Excel Discussion (Misc queries) | |||
How can avoid the security Macro message ... | Excel Discussion (Misc queries) |