Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto link update
Some of the formulas in one of my workbooks (say workbook A) reference cell in another workbook (workbook B). Each time workbook A is opened, window opens with the following: "The workbook you opened contains automatic links t information in another workbook. Do you want to update this workboo with changes made to the other workbook? To update all linked information, click YES To keep the existing information, click NO" If workbook B is not open when workbook A is opened is there a way t automatically update workbook A with all linked information fro workbook B, without having this window show up? -- neb ----------------------------------------------------------------------- nebb's Profile: http://www.excelforum.com/member.php...nfo&userid=898 View this thread: http://www.excelforum.com/showthread.php?threadid=27348 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto link update
I went to help and typed "update links" in the search box. This is the first
hit: Control the startup prompt for updating links Don't ask whether to update links when I open any workbook, and update links automatically This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other programs. On the Tools menu, click Options, and then click the Edit tab. Clear the Ask to update automatic links check box. If the box is cleared, the links are automatically updated, and no prompt is displayed. Don't ask to update links for this workbook, and let me control whether links are updated Warning This option affects all users of the workbook. If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date. On Edit menu, click Links. Click Startup Prompt. Select the option you want. Note You will still be notified if there are any broken links. On Thu, 28 Oct 2004 21:00:52 -0500, nebb wrote: Some of the formulas in one of my workbooks (say workbook A) reference a cell in another workbook (workbook B). Each time workbook A is opened, a window opens with the following: "The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook? To update all linked information, click YES To keep the existing information, click NO" If workbook B is not open when workbook A is opened is there a way to automatically update workbook A with all linked information from workbook B, without having this window show up?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Workbooks - Auto Update | Excel Discussion (Misc queries) | |||
Auto update workbooks link | Excel Worksheet Functions | |||
Auto Update the formula values without opening the link worksheets | Excel Worksheet Functions | |||
Auto Link Update | Excel Discussion (Misc queries) | |||
can i link a cell to a calendar so it will auto update | Excel Discussion (Misc queries) |