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

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

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