excel links popup message - very annoying

[marsenal]

Hi,
I am having problems with the continual popping up of the following message:


"Links to "xxxx.xls" were not updated because "xxxx.xls" was not recalculated before it was last saved.
To update links with current values in "xxxx.xls" click OK.
To cancel updating the links to "xxxx.xls" click Cancel"



This happens within a spreadsheet virtually everytime I create a new link to that particular spreadhseet. So this is using up a lot of time.

It is not practical to update all spreadhseets before saving. So what I am wondering is whether it is possible to switch off this prompt somewhow and let Excel not care that the spreadhseet was not recalculated before it was last saved.

Thanks for all your help.

[twor57]

Sorry, the *.xls reply was not intended for you.

On your issue, there are some options for links under "Edit" then "Links"
that may be helpful.

twor57

>
> "marsenal" wrote:
>
> >
> > Hi,
> > I am having problems with the continual popping up of the following
> > message:
> >
> >
> > "Links to "xxxx.xls" were not updated because "xxxx.xls" was not
> > recalculated before it was last saved.
> > To update links with current values in "xxxx.xls" click OK.
> > To cancel updating the links to "xxxx.xls" click Cancel"
> >
> >
> >
> > This happens within a spreadsheet virtually everytime I create a new
> > link to that particular spreadhseet. So this is using up a lot of time.
> >
> >
> > It is not practical to update all spreadhseets before saving. So what I
> > am wondering is whether it is possible to switch off this prompt
> > somewhow and let Excel not care that the spreadhseet was not
> > recalculated before it was last saved.
> >
> > Thanks for all your help.
> >
> >
> > --
> > marsenal
> > ------------------------------------------------------------------------
> > marsenal's Profile: http://www.excelforum.com/member.php...o&userid=37577
> > View this thread: http://www.excelforum.com/showthread...hreadid=572050
> >
> >

[twor57]

Try going to Explore and search for *.xls on your hard drive.

twor57

"marsenal" wrote:

>
> Hi,
> I am having problems with the continual popping up of the following
> message:
>
>
> "Links to "xxxx.xls" were not updated because "xxxx.xls" was not
> recalculated before it was last saved.
> To update links with current values in "xxxx.xls" click OK.
> To cancel updating the links to "xxxx.xls" click Cancel"
>
>
>
> This happens within a spreadsheet virtually everytime I create a new
> link to that particular spreadhseet. So this is using up a lot of time.
>
>
> It is not practical to update all spreadhseets before saving. So what I
> am wondering is whether it is possible to switch off this prompt
> somewhow and let Excel not care that the spreadhseet was not
> recalculated before it was last saved.
>
> Thanks for all your help.
>
>
> --
> marsenal
> ------------------------------------------------------------------------
> marsenal's Profile: http://www.excelforum.com/member.php...o&userid=37577
> View this thread: http://www.excelforum.com/showthread...hreadid=572050
>
>

[marsenal]

unfortunately none of the options under edit/links solve the problem
nor does changing the tools/options/edit box which says "ask to update automatic links"