You may want to try putting your setting at 'Disable all macros with
notification' then when you open the file, you will get a security warning
above your formula bar select Options and Enable Content.

See if that solves the issue...

"Nylex" wrote:

The Security Settings are "Disable All Macros" except from a trusted site
I have The "GoFigure" folder in the Security Settings as a Trusted Site



"Rayashe" wrote:

What are your Macro Security settings set to?

"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