[SalesForce] How to display image from Static Resource in Excel sheet (generated from VF Page)

I have been facing trouble in rendering image from Static Resource. Could any one help with the same?

The error is:

The linked image can not be displayed. The file may have been moved,
renamed or deleted. Verify that the link points to the correct file
and location

The Static Resource is 'Public'

Best Answer

"public" means accessible from outside over an authenticated connection. So any request needs to include a session id (obtained by the login process) and a request originating from Excel will not have this.

You can provide unauthenticated access to a static resource by setting up a Site and using a URL that starts with the Site domain. Or you can provide access to the image by making it an externally available image Document which is simpler.