If the service is not working correctly, Excel does not update the data. All the latest data is stored in the Excel file and is only replaced if Excel successfully runs the refresh.