| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to skip the confirmation on updating link?
for updating links, under Edit Links, I have specify 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.programming
|
|||
|
|||
|
How to skip the confirmation on updating link?
What version of Excel are you using? In 2003 the option you want is Edit,
Links, Startup Prompt, Don't display the alert and update links. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Eric" wrote: for updating links, under Edit Links, I have specify 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to skip the confirmation on updating link?
I am using XP with SP3 and Excel 2003, and have done your following
instruction, but the message still pop up. If file1.xls includes link connecting to file2.xls, and If file2.xls includes link connecting to file3.xls, and If file3.xls includes link connecting to file4.xls. I have set option not to display alert and update links for file1.xls, but when I open file1.xls, message is still pop up for updating confirmation. Does anyone have any suggestions? Thanks in advance for any suggestions Eric "Shane Devenshire" wrote: What version of Excel are you using? In 2003 the option you want is Edit, Links, Startup Prompt, Don't display the alert and update links. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Eric" wrote: for updating links, under Edit Links, I have specify 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to skip the confirmation on updating link?
"Eric" wrote in message
... for updating links, under Edit Links, I have specify 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 Eric, Is there a reason you started a new thread about this same *exact* subject. Continue in the same thread you started less than 12 hours ago. Do you think by reposting someone will have some magical cure for your issue ? I believe *I* need a magical cure for *your* issue. Your doctor, BB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to skip the enable update confirmation? | Excel Discussion (Misc queries) | |||
| How to skip confirmation for macro and update all links? | Excel Programming | |||
| How to skip confirmation for macro and update all links? | Excel Programming | |||
| How to enable macro and updated link without confirmation? | Excel Discussion (Misc queries) | |||
| When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions | |||
Hybrid Mode
