I am attempting to link multiple workbooks to a single source. utilizing the pastelink feature, most content pastes/updates successfully. Some cells display #n/a even though some adjoining cells in the same range do not have this issue. i am starting to feel like Chris farley in Tommy Boy when he pulls his hair out. please help!