I want to disable updates of automatic links in Excel. If I receive a
workbook with cells that another user has linked to a file from their
temporary folder (emailed attachment?), I can't stop Excel from trying to
update the link and therefore get #REF! msgs.

When I go to Startup Prompt in the Edit Links section and select "'Don't
display the alert and don't update automatic links" option, the file still
doesn't stop returning the error msg.

You might try going to Tools>Options>Calculation tab. Click on Manual
Calculation radio button. You might accomplish it this way.

God Bless

"Bill Hutchinson" wrote:

> I want to disable updates of automatic links in Excel. If I receive a
> workbook with cells that another user has linked to a file from their
> temporary folder (emailed attachment?), I can't stop Excel from trying to
> update the link and therefore get #REF! msgs.
>
> When I go to Startup Prompt in the Edit Links section and select "'Don't
> display the alert and don't update automatic links" option, the file still
> doesn't stop returning the error msg.

Hi Frank,
Thanks for your reply. The problem I'm having is that in Office 2007, I can
only manage to change the calculation (and link update) settings within a
specific workbook, which means I have to open the files to change that file's
settings. Unfortunately, I get the error msgs as soon as I open the file to
change the settings. Is there a way to change my defualt settings in Excel?

Bill
"Frank Pytel" wrote:

> You might try going to Tools>Options>Calculation tab. Click on Manual
> Calculation radio button. You might accomplish it this way.
>
> God Bless
>
> "Bill Hutchinson" wrote:
>
> > I want to disable updates of automatic links in Excel. If I receive a
> > workbook with cells that another user has linked to a file from their
> > temporary folder (emailed attachment?), I can't stop Excel from trying to
> > update the link and therefore get #REF! msgs.
> >
> > When I go to Startup Prompt in the Edit Links section and select "'Don't
> > display the alert and don't update automatic links" option, the file still
> > doesn't stop returning the error msg.

Bill

Yeah. 2007. Good Luck.

God Bless

Frank Pytel

"Bill Hutchinson" wrote:

> Hi Frank,
> Thanks for your reply. The problem I'm having is that in Office 2007, I can
> only manage to change the calculation (and link update) settings within a
> specific workbook, which means I have to open the files to change that file's
> settings. Unfortunately, I get the error msgs as soon as I open the file to
> change the settings. Is there a way to change my defualt settings in Excel?
>
> Bill
> "Frank Pytel" wrote:
>
> > You might try going to Tools>Options>Calculation tab. Click on Manual
> > Calculation radio button. You might accomplish it this way.
> >
> > God Bless
> >
> > "Bill Hutchinson" wrote:
> >
> > > I want to disable updates of automatic links in Excel. If I receive a
> > > workbook with cells that another user has linked to a file from their
> > > temporary folder (emailed attachment?), I can't stop Excel from trying to
> > > update the link and therefore get #REF! msgs.
> > >
> > > When I go to Startup Prompt in the Edit Links section and select "'Don't
> > > display the alert and don't update automatic links" option, the file still
> > > doesn't stop returning the error msg.