If you're still opening the files in different instances, then the "sending"
file needs to be saved before any change will be reflected in the first
workbook.

Then in the receiving workbook, you can use Edit|Links|Update values to get the
newly saved values.

Or if there's only a couple of cells, you can:
select the cell
hit F2, then enter

Excel will think that you're reentering a new formula and reevaluate it.

KandK wrote:

This works great, it is now seeing the information on opening the program and
also changes the information when the day changes (there is three columns on
the worksheet, yesterday, today and tomorrow). However for some reason when I
enter information on the first workbook (Bookings) it does not automatically
update the information onto the other program. I have the Update remote
references in Tools checked and also the Automatic option in the Links dialog
box is checked. Am I doing something wrong or won't this sort of link
automatically update. Any help you can give will be greatly appreciated. Many
thanks.

--

Dave Peterson