A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Auto update a linked Cell



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2009, 03:54 PM posted to microsoft.public.excel.links
TADropik
external usenet poster
 
Posts: 8
Default Auto update a linked Cell

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?

  #2  
Old May 6th, 2009, 04:11 PM posted to microsoft.public.excel.links
Gary''s Student
external usenet poster
 
Posts: 7,584
Default Auto update a linked Cell

Tools Options... Calculation and check Update remote references
--
Gary''s Student - gsnu200851
  #3  
Old May 6th, 2009, 05:46 PM posted to microsoft.public.excel.links
TADropik
external usenet poster
 
Posts: 8
Default Auto update a linked Cell

Can't get that box to say checked.

"Gary''s Student" wrote:

Tools Options... Calculation and check Update remote references
--
Gary''s Student - gsnu200851

  #4  
Old May 15th, 2009, 01:38 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Auto update a linked Cell

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

  #5  
Old May 15th, 2009, 01:11 PM posted to microsoft.public.excel.links
TADropik
external usenet poster
 
Posts: 8
Default Auto update a linked Cell

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.