I have one workbook and I have linked its data between several other workbooks. I stand on a cell in one book and type = , then go to reference workbook, look for the cell I need referenced, hit enter and the formulas gets passed on to the destination workbook. Formula is fine, with $ sign so as to prevent it from changing. When I reopen books everything is changed. The reference cell changes up or down one or two cells giving me different results. This is driving me crazy and I need to work this out soon Please help.