Quote Originally Posted by Mike1001
I'm not sure if that solves all of your problems, but I would recommend to put the formula ='ITT Tracking Plan.xls'!$A$49:$A$50 without the second linked cess, i.e. ='ITT Tracking Plan.xls'!$A$49.

Best
Mike1001
Thanks, Mike...that did the trick! Pretty cool to see an 18 paragraph question answered in 2 lines! thanks, thanks, thanks!!!