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.
Is there a simple way to change the file location in the EDIT>LINKS location as it seems to be defaulting itself to "C:/Documents and Settings..." where in reality the file is located on a Server and in the same folder (I assumer this means I don't need a full path, just the filename.xls bit?)
I've unprotected the sheet and updated the location to the server, which works fine on my machine (XP-Pro, Office XP 2002)...however, on a seperate machine (XP-Pro, Office 2003) the file does not open and the updates do not work.