@ben_hensel, thanks for the response!

I turned on Solver in my 2013 but still getting this error belows so I'm unable to open the file:
"Excel cannot open the file <filename> because the file format is not valid. Verify the the file has not been corrupted and that the file extention matches the format"

How can I get past this?