i tried to change the file extention to see if the file was created in the wrong file format. the way we ended up fixing the issue is the person that created the file changed the sheet name to be less than 30 characters. once he changed the name of the tab the file works with no problem. maybe SSRS allows sheet names of over 30 characters?