Linking Workbooks

  • Thread starter Thread starter Nylex
  • Start date Start date
N

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 said:
What are your Macro Security settings set to?

Nylex said:
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
Click to expand...
Click to expand...
 
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 said:
What are your Macro Security settings set to?

Nylex said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
What are your Macro Security settings set to?

Nylex said:
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
Click to expand...
Click to expand...
Click to expand...
 
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
 
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
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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.....

Nylex said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top