Hi Amy,
If I'm reading you correctly, you want formulae such as =SUM(A1:B1) to
update, but not external links. This is possible, and below I've cut and
apste some text from Excel help (do a search for Update External Link). I
suspect that you're after the last option, which doesn't prompt you to
update your links, but you can do this later on if you so choose.
HTH,
katherine
Control when links are updated
The control of how linked information is updated in Microsoft Excel is
dependent on the type of link used.
Links to other workbooks
The workbook that contains the links is called the destination workbook, and
the workbook that is linked to is called the source workbook. When both the
source workbook and the destination workbook are open, links are updated
automatically. When you open a destination workbook, and the source workbook
is not open, you are asked whether to update the links using a startup
prompt. You can control whether or not the prompt appears, and whether or
not to update all links when the prompt does not appear. You can also update
only some of the links, if the workbook contains more than one.
Update all links or no links in a workbook
1.. Close all workbooks. If one source workbook is left open, and others
are closed, the updates will not be uniform.
2.. Open the workbook that contains the links.
3.. To update the links, click Update.
To not update the links, click Don't Update.
For help deciding which button to click, click Help.
Update only some of the links to other workbooks
1.. Close all workbooks.
2.. Open the workbook that contains the links.
3.. When asked whether to update links, click Don't Update.
4.. On the Edit menu, click Links.
5.. In the Source list, click the linked object you want to update.
To select multiple linked objects, hold down CTRL and click each linked
object.
To select all linked objects, press CTRL+A.
6.. Click Update Values.
Control the startup prompt for updating all 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.
1.. On the Tools menu, click Options, and then click the Edit tab.
2.. 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.
1.. On Edit menu, click Links.
2.. Click Startup Prompt.
3.. Select the option you want.
Note You will still be notified if there are any broken links.
