Refresh PivotTables without Removing timeline

[Macro_Nerd99]

I have a worksheet with several pivot tables that are connected to a timeline. However, when I click the "Refresh Pivot Tables" button that I created, the timeline is always deleted. How do I prevent this?

Here is the code connected to the button:

Sub Refresh_btn_Click()
    Dim PC As PivotCache
        For Each PC In ActiveWorkbook.PivotCaches
            PC.Refresh
        Next PC
        
End Sub
       
Thanks.
[ATTACH type="full"]78076[/ATTACH]

 

[Alex Blakenburg]

Can you check the following:
1) Your time line heading is "Date". Is the column heading of the date field on which the time line is based still called "Date" ?
2) Does the Date column in the table contain any cells with a text value (including dates as text) or any cells with an error value ?
(Easiest way is probably to use a filter and in the filter drop down check for the text and error items which will most likely be at the very bottom)