View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike K Mike K is offline
external usenet poster
 
Posts: 104
Default Absolute cell reference will not remain absolute.

Oh Wise Ones,

Excel 2003 SP
WinXP Pro

I have a date in J4. If I link the contents of J4 to another
workbook by using ***$J$4 and I insert a row where the date in J4 may change,
my linked cell reference is now to $J$5. Why does this happen?

Thanks,
Mike