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.
HTH
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
Thanks for your help:):):)
Don’t have an account yet? Register yourself now and be a part of our community!
