Forum Discussion
Sparklines - Something is preventing them from updating
When examining the file I noticed that it stemmed from a document from 2011. There’s no visible data in the file that’s related to 2011 but originally it’s a template that’s been build upon since then.
If I copy the sparklines from the problem sheet to a new file they work when the problem file has been closed and excel restarted. So the problem must lie in some residual data from 2011. I haven’t figure out exactly what’s the problem but the whole thing can be avoided if I update all my templates to new documents. Not exactly a solution but a work around.
I still have the problem that old documents hinders excel from calculating sparklines in new documents if there open at the same time so If anyone reads this in the future and know what could cause such behavior, please leave a comment below.
On which version of Excel you are? I reproduced such behavior on beta channel, but on other ones it works as expected.
SergeiBaklan I'm using 365 on version 2010 (version 13328.20356 Click-to-run)