First, open the shared Excel file
Select REVIEW tab -> Share Workbook
When you select Share workbook the first time the below trust center message will appear, select Ok.
On Excel menu click on File -> options -> Trust Center -> Trust Center Settings
Then select Privacy options and uncheck Remove personal information from file properties on save box.
Select Save and close
Finally, Select REVIEW tab once again -> Check Allow changes by more than one user at the same time. This also allows workbook merging. -> Ok.
Now you can open and manipulate your Excel file from more than one client machine .