| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
start up prompt for updating links
I have linked cells from one workbook to another and they will be used by
multiple users. I want the links to be automatically updated without each user having to update them, is this possible? I tried edit, links, startup prompt, and selected don't displat the alert & update links, but when I reopen it still asks me if I want to update the link. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
start up prompt for updating links
TOOLS
OPTIONS EDIT Tab Uncheck "Ask to update automatic links" OK HTH, Elkar "egarcia" wrote: I have linked cells from one workbook to another and they will be used by multiple users. I want the links to be automatically updated without each user having to update them, is this possible? I tried edit, links, startup prompt, and selected don't displat the alert & update links, but when I reopen it still asks me if I want to update the link. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
start up prompt for updating links
You must also go into ToolsOptionsEdit and uncheck "ask to update automatic
links" Gord Dibben MS Excel MVP On Mon, 26 Feb 2007 06:46:09 -0800, egarcia wrote: I have linked cells from one workbook to another and they will be used by multiple users. I want the links to be automatically updated without each user having to update them, is this possible? I tried edit, links, startup prompt, and selected don't displat the alert & update links, but when I reopen it still asks me if I want to update the link. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EditLinksStartup Prompt | Excel Discussion (Misc queries) | |||
| Prompt to update links | Links and Linking in Excel | |||
| Update links prompt not wanted | Excel Discussion (Misc queries) | |||
| External Data Source updating on open, how to turn back on prompt. | Excel Worksheet Functions | |||
| Prompt before updating values | Excel Worksheet Functions | |||
Linear Mode
