| Next: how do i turn on the tab over function |
| Author |
Message |
TADropik
External
Since: May 05, 2009
Posts: 3
|
 Posted: Tue May 05, 2009 7:54 am Post subject: Auto update a linked Cell
Archived from groups: microsoft>public>excel>links (more info?) |
|
|
I have a workbook named Template.xls with a formula in a cell:
='C:\Data\[Data.xls]Data'!$B$1
While Template.xls is closed, the data in 'C:\Data\[Data.xls]Data'!$B$1
changes
I open Template.xls and the cell has NOT updated.
Isn't there a way to automatically refresh formulas on start up? |
|
| Back to top |
|
 |
Gary''s Student
External
Since: Oct 01, 2005
Posts: 3350
|
Posted: Wed May 06, 2009 8:11 am Post subject: RE: Auto update a linked Cell [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
|
| Tools > Options... > Calculation > and check Update remote references
--
Gary''s Student - gsnu200851
|
|
|
| Back to top |
|
|
TADropik
External
Since: May 05, 2009
Posts: 3
|
Posted: Wed May 06, 2009 9:46 am Post subject: RE: Auto update a linked Cell [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Can't get that box to say checked.
"Gary''s Student" wrote:
> Tools > Options... > Calculation > and check Update remote references
> --
> Gary''s Student - gsnu200851 |
|
| Back to top |
|
|
Bill Manville
External
Since: Jul 30, 2004
Posts: 539
|
Posted: Thu May 14, 2009 8:10 pm Post subject: Re: Auto update a linked Cell [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Your Excel formula link is not a "remote reference" but an "external
link". What happens on opening the workbook depends on the version of
Excel you are using - please advise.
In Excel 2003, look for the Edit > Links > Startup Prompt setting.
Change it if necessary to "Let users decide whether to display the
alert or not".
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup |
|
| Back to top |
|
|
TADropik
External
Since: May 05, 2009
Posts: 3
|
Posted: Fri May 15, 2009 5:11 am Post subject: Re: Auto update a linked Cell [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?) |
|
|
Bingo . . . This works EXCELLENT.
We are using Excel 2003 SP3
Thank you for your help.
"Bill Manville" wrote:
> Your Excel formula link is not a "remote reference" but an "external
> link". What happens on opening the workbook depends on the version of
> Excel you are using - please advise.
>
> In Excel 2003, look for the Edit > Links > Startup Prompt setting.
> Change it if necessary to "Let users decide whether to display the
> alert or not".
>
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup
>
> |
|
| Back to top |
|
|
|
Microsoft Office