I need to click on the "PENDING" option in excel but the mouse click option is not able to capture, would anyone have a solution

That’s not correct for what you’re trying to do. You are doing UI Automation - trying to interact with things on the screen. For that you should use Use Application/Browser. Then your click will work.