• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Really Slow Editing Charts

Michael67

New Member
Not sure what I changed but now when I open charts and do anything with them it is extremely slow. Says not responding for a bit then comes back in 3 seconds or so for every action. I have opened some files from a 1997 version in compatibility mode but it also applies to newly created files even after a reboot. Any ideas? I did change the default template recently and deleted the other custom templates I had.

Thanks.
 
Check that you aren't referencing entire columns or rows of data for the charts
Chart ranges should be defined either statically as a Range or Dynamically through a Named Formula, but either way shouldn't reference the entire Column or Row
 
No have not changed anything there. Could it be with pdf add in? Or I have a factset add in too. It was working fine and now it's not. I've been converting excel 97 to excel 2010 files. But happens even when I open 2010 only files.
 
Back
Top