I have a pivot table on my excel sheet. I have updated the information there including pivot fields (dates changed). When I press refressh, the whole table disappears
You may want to check your data source via PivotTable Analyze tab menu | Change Data Source menu. Also, if the field names changed in the source data, then the pivot was refreshed, the pivot will remove the old fields - new fields would have to be re-added.