Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2013 animation feature....
Just updated to Office 2013 and opened a spreadsheet that I have
developed only to find it now ran like dog. You could literally watch the movement when you changed cells. Apparently this version has animation built in. There is a fix but it's not intuitive. It involves going to the Ease of Access centre in Control panel. You select use the computer without a display and then tick the checkbox turn off unnecessary animation. Voila your spreadsheet responds quickly again. Why Microsoft WHY??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2013 animation feature....
"XR8 Sprintless" wrote in message ... Just updated to Office 2013 and opened a spreadsheet that I have developed only to find it now ran like dog. You could literally watch the movement when you changed cells. Apparently this version has animation built in. There is a fix but it's not intuitive. It involves going to the Ease of Access centre in Control panel. You select use the computer without a display and then tick the checkbox turn off unnecessary animation. Voila your spreadsheet responds quickly again. Why Microsoft WHY??? Indeed! That said I don't think how it affects how it actually runs in terms of calculation etc. But instead of changing system settings could add this HKCU\Software\Microsoft\Office\15.0\Common\Graphic s\DisableAnimations value 1 May need to add a key for Graphics and DWord for DisableAnimations Regards, Peter T |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2013 animation feature....
On 10/06/2014 11:36 PM, Peter T wrote:
"XR8 Sprintless" wrote in message ... Just updated to Office 2013 and opened a spreadsheet that I have developed only to find it now ran like dog. You could literally watch the movement when you changed cells. Apparently this version has animation built in. There is a fix but it's not intuitive. It involves going to the Ease of Access centre in Control panel. You select use the computer without a display and then tick the checkbox turn off unnecessary animation. Voila your spreadsheet responds quickly again. Why Microsoft WHY??? Indeed! That said I don't think how it affects how it actually runs in terms of calculation etc. It does affect data entry though albeit in a minor annoying way. But instead of changing system settings could add this HKCU\Software\Microsoft\Office\15.0\Common\Graphic s\DisableAnimations value 1 May need to add a key for Graphics and DWord for DisableAnimations Thanks for that. It works. Surely Microsoft could have had a tickbox in the options menu to disable it. It's definitely not intuitive. Also this disable animations across the whole office platform not just in excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 | Excel Programming | |||
Excel 2013 Merge Data | Excel Programming | |||
Help creating new functions for Excel 2013 | New Users to Excel | |||
animation in excel | Excel Worksheet Functions | |||
If it's possible to use animation in Excel? | Excel Discussion (Misc queries) |