Hi there.

With a file I have that has lots of links, when I opened it in Excel 2003 I could specify whether to update links. Now when I open it up in 2007, I am not asked.

I went ti Office Button -> Prepare -> Edit links to files and Automatic is selected but I can't select Manual as it is greyed out.

Any ideas?

Thanks for your time.