Timeline just stopped working

[tp2468]

Hi All,

I have a pivot table that uses the excel timeline feature. I have the appropriate column formatted as date and it has been working perfectly up to this point. However, it has just suddenly stopped working and I get the error message that I have no columns in date format. The workbook does import extra data each day but I have checked this and everything appears to be in the correct data format.
What is even stranger is if I copy the data to a new workbook, I do not get this problem and am able to setup a timeline.

Any suggestions as to why this is happening?

Many Thanks

Tom

 

[SpillerBD]

Is that workbook reverting to "Manual Calculations" ?
Check the PivotTable Options, Data tab, "Number of items to retain per field" is set to none. IF an invalid value was captured, it will persist under other settings and break the timeline feature.