Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2012, 12:19 PM
Intruder Intruder is offline no automatic update from external source file Windows XP no automatic update from external source file Office 2007
Advanced Beginner
no automatic update from external source file
 
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-08-2012, 08:03 PM
macropod's Avatar
macropod macropod is offline no automatic update from external source file Windows 7 64bit no automatic update from external source file Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I'm not sure what you mean by:
Quote:
when the master template is updated with an extra keyword at the end of one list
but some external references only ever update correctly when the source file is open. It might also be worthwhile checking the link update settings. If you add the 'Edit Links' button to the QAT, clicking on that, then 'StartUp Prompt' will reveal whether Excel is set to update them.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
no automatic update from external source file drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
no automatic update from external source file vba change external data source excelledsoftware Excel Programming 1 07-17-2012 04:22 AM
no automatic update from external source file 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft