Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Link Update
When i sign into my spreadsheet it asks whether i would like to update links. Is there anyway to get this to auto update without it prompting me. Basicaly taking away the choice from the user? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=399731 |
#2
|
|||
|
|||
You can change the setting for you.
Tools|options|Edit tab Uncheck "ask to update automatic links" The links will be refreshed and you won't be prompted. But this is a setting that's local to you--each user controls what he/she wants to do. ceemo wrote: When i sign into my spreadsheet it asks whether i would like to update links. Is there anyway to get this to auto update without it prompting me. Basicaly taking away the choice from the user? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=399731 -- Dave Peterson |
#3
|
|||
|
|||
is there any other way to this just to this spreadsheet for all users -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=399731 |
#4
|
|||
|
|||
I don't think there's a reliable way (except for walking around and changing
that setting). But another approach is to use a dummy workbook that opens the workbook with links. You can have that dummy workbook open your real workbook anyway you want. The dummy workbook would contain a macro like this: Kind of like: Option Explicit Sub auto_open() Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1 ThisWorkbook.Close savechanges:=False End Sub Then you open the dummy workbook and the links will be refreshed. (read about that UpdateLinks argument in VBA's help.) But now you have a different problem--you have to make sure that the user opens the file with macros enabled. I add some notes to Sheet1: Please close this workbook with macros enabled. (Repeated about 20 times) Then if macros are enabled, the message disappears quickly. If macros are disabled, then the users can read the message and do what they want/need to do. ceemo wrote: is there any other way to this just to this spreadsheet for all users -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=399731 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I disable auto formula update? | New Users to Excel | |||
can i link a cell to a calendar so it will auto update | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
auto update an open excel sheet over network, with mutiple users | Excel Worksheet Functions | |||
auto update | Excel Worksheet Functions |