I have an Excel template which is linked to data in another workbook (source/destination). My problem is this:
When I open the destination file, if the source file is not already open, the links do not work and return errors in the linked cells (which use the IF and OFFSET commands). If the book is open links are fine, but not if it isn't.
What I really want to do is set the template (destination) file up to automatically open up the source file on opening. It works if I set it up to open all the time, but of course, this makes it a drag to open new blank workbooks up.
Any help please?
This thread is now locked and can not be replied to.