(1) I receive worksheet A by email. The person who sent it did not copy, paste, values and therefore it comes in with links to worksheet B to which I do not have access. In Excel 2000, I only had to say No to "Update Links" when I opened worksheet A. Even though, the cells would reference a non-existent worksheet, the values that it had stored when it was last saved would be displayed. This does not work with Excel 2007. All I can see is VALUE# errors.

(2) When I copy a file from, say, the J drive (with links to another file in J), to the C drive, all of the links to J files now get automatically changed to C, where there are no such paths and files. Excel 2000 never did this, unless I copied the entire folder filled with inter-connected worksheets.

Please help! I receive a lot of worksheets with problem 1 and it is becoming a big issue. I have been opening them in Excel 2000 and working from there which is like going back in the evolutionary process!

Thanks!