Thanks for your reply. Yes, it is set to automatic update but every time I open the file I always get a pop-up box that says "This document contains links that may refer to other files. Do you want to update this document with the data in the linked files?"