Check that BatchView is selected in the addins as described here: PI BatchView . Do you recieve any errors when selecting BatchView after following the KB? BatchView should work fine in 32 bit office 2016 although it never was officially test with office 2016.
The #Name? typically means Excel doesn't recognize the batchview formula.
Already done that. but PIBVSearch function still didnt recognize by excel.
Not sure why. have any other idea?