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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
Auto update a linked Cell
Tools Options... Calculation and check Update remote references
-- Gary''s Student - gsnu200851 |
#3
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|