Thanks for all your help

Renamed my Macro to Auto_Open and now it works fine

Tks again

"Nylex" wrote:

I have a Summary Workbook and it gets information from other workbooks

Whenever I open it it will not update - it has an entry of 0 - I have to go
through the tedious task of doing it manually

This is what is in the Cell

='C:\Program Files\GoFigure\[Projection.xls]Sheet1'!$A$38

I am using Excel 2007