Calc Charts stop updating until file is reloaded

I am running LO Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 10.0 Build 19041.630; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
But I have noticed this behavior in earlier versions.

I have a spreadsheet containing 13 worksheets 12 of which contain two charts each. I have noticed that sometimes when I switch between worksheets the charts will stop updating when I enter new data into the worksheet. I can get them to start updating again by reloading the file.
Has anyone else seen this behavior?

This still occurs in version 7
Version: 7.0.6.2 (x64)
Build: 144abb84a525d8e30c9dbbefa…
Environment: CPU threads: 4; OS: Windows 10.0 Build 19041
User Interface: UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Misc: Calc: threaded

I have a simple workbook with summary tables and two charts.
The charts refused to update, I tried editing the charts, changing the type etc and still the old data was appearing.

I tried resizing the charts.

Eventually CTL + SHIFT + F9 did the trick…

I had tried F9 to recalculate, however the tables had the correct info, really frustrating.

Version: 7.3.1.3 / LibreOffice Community
Build ID: 30(Build:3)
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.utf8); UI: en-GB
7.3.1-1
Calc: threaded