It's really annoying to wait for an hour for a bunch of queries to refresh only for an '#N/A' value in an excel table cause the entire load to crash. There should be a prompt that asks if you want to continue refreshing other tables that aren't tied to the one with the error, avoiding the need to wait for an hour to see an error message.