I'm trying to find a way to stop linked documents being automatically
refreshed in Excel 2007. In 2003 you used to get a pop-up that prompted if
you wanted to update your links or not. 2007 doesn't do this and
automatically updates them. I have tried unticking the box for "update links
to other documents" but they still update.

I noticed in the Edit links section it has a bit for Update:
Automatic/Manual but Manual is always greyed out.

I also tried the macro that Tom Ogilvy and Jason put up but that doesn't
work either.

Please help!