Linking Workbooks

[Nylex]

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]

What are your Macro Security settings set to?

 

[Nylex]

What are your Macro Security settings set to?

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

 

[Nylex]

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

What are your Macro Security settings set to?

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]

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...

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

What are your Macro Security settings set to?

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

 

[Nylex]

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]

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

 

[Rayashe]

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?

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

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]

Also just try Developer>Macro Security>Macro Settings>Enable 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 Centre>Trust Centre Settings>Macro Settings.....

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

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

 

[Nylex]

Thanks for all your help

Renamed my Macro to Auto_Open and now it works fine

Tks again