Hi Syed,
From your description, you can’t open an object in Excel workbook which can be opened by other team members.
I found that this error usually happens when the Excel version is old. In other threads, users fixed this issue by updating Office application. (Excel-> File-> Account-> Product Information-> Update Options.)
If you have already used the up to date version, you can try Online Repair to fix this issue. Please follow the steps in this article: Repair an Office application
If still can’t open this object, you can copy this object into another workbook to check whether you can open it. In the meantime, please provide the screenshot of Excel-> File-> Account-> Product Information page. It will help us understand better.
Appreciate your cooperation.
Best Regards,
Ivy