Excel chart doesn't refresh -

a colleague , have issue refreshing of charts in excel.

the issue chart doesn't update when source data changed. first time happens me , checked everywhere online , don't see reported issues similar have or provide more satisfying solution vba code.

it simple graph really. correctly linked source (no values hard coded). calculations set on automatic workbook. don't know can come from.

i tried setting other chart in same worksheet, linked 1 simple row , new chart has same refreshing issue suspect has settings or life of me can't find settings this.

every time want see updated version of have either delete serie , add again or re-open file.

another colleague came same issue on different computer/file/data/chart.

edit : created chart in same worksheet this: 1, 2 , 01/02, 01/03

so 1 , 2 source data , dates x axis.

if change 2 3, chart continue display 2. after recalculation excel. seems affect whole workbook.

the quickest way seem have getting refreshed chart cut , paste chart.

apparently, happen if have . in tabpage name. excel doesn't seem . in tab names , got error when tried add new chart:

some chart types cannot combined other chart types

when searched error, got this page helped me understand root cause. renamed tab remove . , charts still wouldn't update. ultimately, had click on each series , reselect source them updated.

when renamed tab page, there no error, internal error must have caused charts freeze , disconnected cell references.