I have built dynamic charts into a spreadsheet using microsoft 365 and all charts are working perfectly, however when I open it on another computer that only has excel 2007 charts are not updating automatically is there a way around this? Ive also tried to save as a 2007 spreadsheet but still not working. Is there a macro that can be used or anything else? any help is appreciated. I have built the charts from tables.