Error when trying to access linked server from another machine
You put no details about the involved paths in your post so I'm just making wild guesses.

You can run the query from any machine in your network but the path you save the excel file into must be accessible by the user executing the RDBMS service (usually local network or local service but may be customized at will).

The path you put into the linked server configuration is always local to the server.  Even when running the query from a client machine the excel file must be on the server. (Well, you may specify a UNC network path when creating the linked server but that  would make the whole thing more 'funny' to debug and handle because of permissions.)