Hi,

Actually the solution is to NOT choose Enable content related to links.
That is the equivalent of the old negative response to Update Links? You can
just leave the security bar on screen it will do nothing unless you enable
content.

--
Thanks,
Shane Devenshire


"Andy Clark" wrote:

I have a lot of Excel 2003 spreadsheets that I cannot change from a
thirdparty. When I opened them in Excel 2003 as was able to not update the
links and show the previous data.
No matter what combination of settings I put in to Excel 2007 it is not
showing me the previous data just #Name where the link would be.
can anyone give me a pointer as to what I can do to resolve this.
I get the security warning and reply Enable content
I then get an alert abouts links that can't be updated - I reply continue
and that is it.
I have no option to Display Previous data as I did in Excel 2003

Many thanks