How do I link separate files so all update when I alter one?

's Computer Specifications

I wish to have some files /folders that contain similar fields. What do I
need to do so that when I update one the rest follow suit automatically?

's Computer Specifications

use links:

=[Book2]Sheet1!$F$6

when a file with an external link is opened, Excel can be configured to
either update linked material automatically or ask you.
--
Gary''s Student
gsnu200712

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update source link in MANY files	cksiz	Microsoft Excel Worksheet Functions	1	4th Dec 2007 10:25 PM
Link Tables using Alter Table command	=?Utf-8?B?ay5sb2FkZXI=?=	Microsoft Access VBA Modules	2	12th Sep 2007 07:24 PM
Open Separate Excel Files in Separate Windows	JTWood	Microsoft Excel Misc	3	7th May 2006 10:18 PM
How do I link separate Excel files to one spreadsheet?	=?Utf-8?B?ZWtsdXNoaW4=?=	Microsoft Excel Misc	0	6th Jan 2006 08:38 PM
Open Excel files in separate sessions, not just separate windows?	=?Utf-8?B?Qm9iIGF0IERleGlhIERlc2lnbg==?=	Microsoft Excel Misc	1	18th Oct 2005 05:46 PM