If the source workbook is open the links in the dependent workbook will
update when you do a manual or automatic calc. I don't think you can stop
that. If the source workbook is closed and you have Ask to Update Automatic
Links selected under Tools, Options, Edit then you'll be asked if you want
the links updated when you open the dependent workbook. In Excel 2002 and
2003 you can control this prompt (under Edit, Links). One option is don't
ask and don't update, which is what you want. But again, this only applies
if the source workbook is closed.
--
Jim Rech
Excel MVP
| How do you keep the link file from updating? Any
| suggestions? I would like to freeze the data for a period
| of time...
| >-----Original Message-----
| >Manual updates are not available for normal Excel formula
| links. They only
| >apply to "remote" links such as you get through Insert,
| Object, Create from
| >File, Link as File.
| >
| >--
| >Jim Rech
| >Excel MVP
| >| >| Hi, can you tell me how to change a linked file from
| >| automatic update to manual update? In the pop-up window
| >| displaying the linked files the 'manual' radio button is
| >| grayed out; can you tell me how to turn turn it on?? Is
| >| there another setting that must be changed under Tools >
| >| Options??
| >|
| >| Thank you,
| >|
| >| Dennis Lord
| >
| >
| >.
| >
