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

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

"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

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

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

The only way that I can update the cells is if I open the spreadsheet that
has the data
I think the problem might be that the accounting software saves the file as
Excell 2003 format
I tried to put in a Macro to open the file with the data when this one opens
but it wont save the macro - it says it is a macro free workbbook
Should of stayed with Office 2003


"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

If I open the file with the Data in it then the main spreadsheet is updated
The problem may be that the accounting software saqves the file in format
excel 2003
I tried to insert a macro to open the other file when the main one is opened
but it wont save the macro - says it is a macro free workbook
Should have stayed with Office 2003 - never had any of these problems


"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

That's not a problem. If you select Save As, Save as Type: Macro Enabled
workbook, it will allow you to save down the spreadsheet with the macro -
just delete the un-macro enabled spreadsheet when done.

Another thing - what is your calculation set at? Manual or Automatic?



"Nylex" wrote:

The only way that I can update the cells is if I open the spreadsheet that
has the data
I think the problem might be that the accounting software saves the file as
Excell 2003 format
I tried to put in a Macro to open the file with the data when this one opens
but it wont save the macro - it says it is a macro free workbbook
Should of stayed with Office 2003


"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

Also just try DeveloperMacro SecurityMacro SettingsEnable all macros.
Close the spreadsheet and then re-open it to see if it allows the values to
update.

If you do not have the Developer Tab available on your screen then go to
Excel Options Trust CentreTrust Centre SettingsMacro Settings.....

"Nylex" wrote:

The only way that I can update the cells is if I open the spreadsheet that
has the data
I think the problem might be that the accounting software saves the file as
Excell 2003 format
I tried to put in a Macro to open the file with the data when this one opens
but it wont save the macro - it says it is a macro free workbbook
Should of stayed with Office 2003


"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

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