Posted 11 April 2005 - 03:47 AM
your problem lies here:
But the thing is that file 1 is updated every week, aka the file name changes every friday.
You are overwriting
the data in the same 'book' each week. The cells you are trying to link to have been renamed and essentially no longer exists.
Is it not possible to copy the book and change the name of the copy to the new date, this will preserve all the formatting, etc. Thus books for every date so far will still exist and you can link to them in your Times book. You can link to files of future dates, you'll get a REF# error, but when the book is created the data will appear.
Edited by Rimmer, 11 April 2005 - 03:49 AM.
Soltek QBIC, Pentium 4 3.0GHz, 512MB RAM, 200GB SATA HDD, ATI Radeon 9600XT 256MB, Netgear 54Mb/s WAP, ridiculously expensive Satellite Broadband
Windows XP Home SP2, Trend Micro Internet Security, Firefox, Thunderbird, AdAwareSE, Spybot S&D, SpywareBlaster, A-squared Free, Ewido Security Suite.