Home |
Search |
Today's Posts |
#1
|
|||
|
|||
External links
Hello,
I have a sheet with a bunch of links to external data, which is just another workbook. The links are created with a formula. Now, the links will not update unless I have the other books open too. Is there a way to update them automatically? Excel doesn't want to ask me if I want to update them automatically. Thanks, Andrew |
#2
|
|||
|
|||
Check under Tools/Options/Edit and make sure Ask To Update Automatic Links is
checked. "Andrew Clark" wrote: Hello, I have a sheet with a bunch of links to external data, which is just another workbook. The links are created with a formula. Now, the links will not update unless I have the other books open too. Is there a way to update them automatically? Excel doesn't want to ask me if I want to update them automatically. Thanks, Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Using variable in external links | Excel Discussion (Misc queries) | |||
external links | Excel Worksheet Functions | |||
How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
Pivot tables, external data sources and ODBC links | Excel Worksheet Functions |