UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> How to kill 'update links' startup prompt???    
 
   
KCCasey
post Dec 15 2003, 04:15 PM
Post #1

New Member
Posts: 2
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!
Go to the top of the page
 
+
NateO
post Dec 15 2003, 04:41 PM
Post #2

Remembered
Posts: 5,055
From: Minneapolis, MN, USA
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
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 04:50 AM