You still have not told us what the error message is that Excel pops up and you click on.

Excel is Excel and knows how to repair broken files. Perl does not know how to repair broken files.

I recommend you get a valid version of the file instead of a broken file.