| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
|
Auto update a linked Cell
Tools Options... Calculation and check Update remote references
-- Gary''s Student - gsnu200851 |
|
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell linked to worksheet won't update once data is provided. | Excel Discussion (Misc queries) | |||
| Auto Update Linked data | Excel Worksheet Functions | |||
| How do I have a linked cell auto-size to fit the linked data? | Excel Discussion (Misc queries) | |||
| how do i auto update cell values after pasting linked references | Excel Worksheet Functions | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
Linear Mode
