+ Reply to Thread
Results 1 to 6 of 6

2013 cell change animation

  1. #1
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    2013 cell change animation

    In Excel 2013, there is a transition in the cell when values change. I have a DDE feed updating data every few seconds and the folding animation is distracting. Is there a way to turn this off?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,807

    Re: 2013 cell change animation

    I dont have 2013, but have you checked to see if this is happening because of cinditional formatting?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: 2013 cell change animation

    @FDibbins - it's just a standard transition from the box (no conditional formatting)... like the slide transitions in Powerpoint.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,081

    Re: 2013 cell change animation

    Nothing within Excel. There are suggestions for a registry hack.
    http://blog.degree.no/2013/03/office...tions-effects/
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    03-10-2005
    MS-Off Ver
    Excel 2013
    Posts
    95

    Re: 2013 cell change animation

    hi,

    i turn off animation when scroll/moving from one cell to another is :
    - click start, right click on computer choose properties
    - go to advanced systems setting
    - choose Advanced, click settings on performance
    - then on Visual Effects click Custom then unclick Animate controls and elements inside windows

    now i have smooth moving like excel 2010 from one cell to another cell

  6. #6
    Registered User
    Join Date
    11-25-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: 2013 cell change animation

    thanks @koi, that did the trick.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1