Hi,

I have a workbook that is open constantly on our helpline wallboard. A couple of the cells point to other cells in a different workbook which we update daily.

My problem is that when we make the updates the sheet on the wallboard doesn't update unless I close and re-open, or I open the other sheet on that pc. Is there any way of auto refreshing and pulling the data?

I've tried the F9 (calculate) in a macro that runs every 15 minutes, but it doesn't refresh the data from the other sheet....

Any ehlp would be appreciated...
Thanks