Do you know if the workbook that you are working with is from an earlier version of Excel where the Sparklines are not compatible. This issue would still be present even after copying and pasting to a new worksheet. Just a thought.