absolute links to a source file
Posted by dm on August 06, 2001 4:16 PM
I have several worksheets which pull data from other sheets. I need these to be constantly live with up-to-date data. The problem is, every week I save copies of the source files for archive purposes, and the links go with the saved version, rather than staying with the master version. For example, I go to look at my sales summary at the end of July and I find that the numbers are not being pulled from "Sales worksheet.xls" but from "Sales Worksheet Snapshot June 5.xls". I wonder if I can put anything in the link to to make it look for the data in the same place, even if I "save as" the source file. Help please.