Dec 15 2003, 04:15 PM
Okay, I'm putting an Excel workbook on a shared network drive that has some graphs in it, so that the management can view the latest updates to the graphs. The graphs are linked to another workbook. I would like for people to be able to open up the workbook on the shared drive without the startup prompt popping up, asking whether to update the links or not. When anyone opens up the workbook, I want the links to update without the prompt popping up. According to "Excel Help", all I have to do is open the shared drive workbook, open the 'edit links' dialog box, click the 'startup prompt' button, and select "don't display the alert and update links". Okay, I did that and saved the workbook, but the prompt STILL POPS UP!!! grrr. Any advice would help save what's left of my hair. Thanks!
Dec 15 2003, 04:41 PM
You're using XP I trust...
Surprised that doesn't work... Otherwise, you'll have to:
1) Live with it
2) Alter the way you gather your data source for the charts to some sort of implimentation of either automation, ole db or odbc
2) Open the Workbook via VBA