The problem could be with HR security profile attached to the responsibility from where you are launching the spreadsheet. Check it once.
The issue was happening because PER_ALL_PEOPLE_F.FULL_NAME had a space at the end, egs- "Last, First Mr. "
We've created a view and the TRIM(FULL_NAME) is used as the display value in the LOV. \