Hi

I've tried looking on the forum for this question, but I didn't see anything. I'm a long time Excel user but have only been using Excel 2007 for about 6 months. There is something new that I just can't find a way around. In Excel 2003 when you copied a worksheet that contains links to another workbook it would reference the 1st workbook. In Excel 2007 it uses the same links as workbook #1 instead of referencing the 1st workbook.

For example, I have a workbook (#1) that contains many columns of data for the whole state. Some columns are populated by linking to the sheet "basic + the cell". Other columns are populated by linking to the file "last year".

For workbook #2, I prepare another file for a district in that state (so not all of the information). I would normally do that by copying the data from workbook #1 and deleting what I don't need for the district in workbook #2 and workbook #2 would link to workbook #1.

I never had any problems with this method but now when doing this in Excel 2007, the new sheet in workbook #2 instead of referencing the sheet in workbook #1 now links to workbook #1 and last year's file instead of linking to last year's data in the master file. I don't want that. The idea is that once the master workbook (#1) is updated, all the other workbooks update based on that one. The way it is copying means that I may potentially run into a problem and have several files to check instead of one.

Help! What am I missing?