• How do I change the links to a page from Automatic to Manual?

    The problem that I am having is that I only want to open up the linkpage without opening the page where all the links belong too? Please help!!!

    I was thinking if I could change from Automatic to Manual that may help my problem, but I don't know how.

    Thanks in advance for your help!!!!

  • This what you mean? From the (xl2k2) help file:

    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.


    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  • Ok,

    I follow the directions, but I am still coming up with an error message when I open up the main file. The error message states, "FILE NOT FOUND." How do prevent that message from coming up?

    Thanks for your help

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!