#1
|
|||
|
|||
no automatic update from external source file
I have a 'Master Templates' with several sheets (including 1 called 'General') containing lists of keywords.
These keywords are copied into a 'Slave Template' sheet in a different workbook (and later used for named ranges and defining lists) in the template is the following formula used for copying; IF('name of server\[Master Templates.xlsx]General'!A14="","",'name of server\[Master Templates.xlsx]General'!$A14) when the master template is updated with an extra keyword at the end of one list, the 'Slave Template' is not updated automatically unless both files are open Can this not be updated with the Master Template closed ? using Excel 2007 |
#2
|
||||
|
||||
I'm not sure what you mean by:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
drop down list from external data source Excel 2007? | Intruder | Excel | 1 | 08-03-2012 05:41 AM |
vba change external data source | excelledsoftware | Excel Programming | 1 | 07-17-2012 04:22 AM |
Refresh of data from external source | Jirik61 | Excel Programming | 3 | 07-13-2012 01:40 PM |
Linked Image automatic update? | uzapuca | PowerPoint | 0 | 04-23-2011 02:03 AM |
Any External tool to update word dcoument without opening doc? | nagendra.prasad.m | Word | 0 | 09-15-2009 09:39 AM |