SSRS and Odata Data Feed

Hi.

I have created an excel spreadsheet that grabs live information from the SSRS report using Odata Data Feed (Atomsvc file).

My spreadsheet is designed to grab several tables from various reports however when there is no entry on one of the tables in one the reports, the SSRS report deletes the table and then my spreadsheet can no longer connect to that table and throws an error popup.

Does anyone know a way to either get excel to make a blank entry on excel or read another file. Even if i could disable the popup that would be great, i need 100% automation

Thanks