| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing to external name range that would updateautomatically
Chris wrote: is there any way that i could have all my other worksheets import defined name ranges from a source worksheet? and having them update every time i open them or change the ranges in the source? appreciated. i'm starting to get tired and frustrated.... thanks. I'm not sure what your problem is exactly, but have you tried using data - import external data - new database query - databases - excel files, instead of just linking to files? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clarification - how to automatically update cells with a date and date range | Excel Discussion (Misc queries) | |||
| using weekday formulas to automatically update a date range | Excel Discussion (Misc queries) | |||
| Help - Create a range that will update automatically to be used in formula | Excel Programming | |||
| automatically update pivot tables when dynamic named range is expa | Excel Discussion (Misc queries) | |||
| How do I automatically update a chart range in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
