| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do not Update On Open
I have a Linked worksheet that I am saving as a new Workbook. When I
open the new Workbook it ask me if I want to update the workbook. Can i automatically say "No". I looked in the help file but I am still confused. Thanks, Brian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Do not Update On Open
Brian,
Yes, you can make this work. Save it as a new workbook but keep it open. Then do Edit Links Startup Prompt Don't display the alert and don't update the links Then save it again close reopen hey presto -- Allllen "Brian" wrote: I have a Linked worksheet that I am saving as a new Workbook. When I open the new Workbook it ask me if I want to update the workbook. Can i automatically say "No". I looked in the help file but I am still confused. Thanks, Brian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Do not Update On Open
The Manual option is not highlighted.
Can I use a wookbook event(open, activate) to say no to the prompt. Allllen wrote: Brian, Yes, you can make this work. Save it as a new workbook but keep it open. Then do Edit Links Startup Prompt Don't display the alert and don't update the links Then save it again close reopen hey presto -- Allllen "Brian" wrote: I have a Linked worksheet that I am saving as a new Workbook. When I open the new Workbook it ask me if I want to update the workbook. Can i automatically say "No". I looked in the help file but I am still confused. Thanks, Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update workbook on open | New Users to Excel | |||
| Why will links not update unless source is open? | Excel Discussion (Misc queries) | |||
| How do I open Excell after an update that went bad? | Excel Discussion (Misc queries) | |||
| open without link update | Excel Programming | |||
| Update Links on file open | Excel Programming | |||
Hybrid Mode
