Excel (Office 365) now slow because of gimmicks

[Anchundan]

My work has just updated all our computers to Office 365. I mainly use Excel spreadsheets, typically with 200 to 300 sheets in one file.

For some reason with Excel, now if you click on a cell, the highlight box sort of 'drifts' from the old location to the new location, rather than snapping to that location.

Also, if you enter a formula, or a number which affects formulas in other cells, Excel waits for a few milliseconds, before producing the result, and again, the result doesn't appear instantaneously, it sort of scrolls down from the top of the cell. This is slow, annoying, and an unprofessional gimmick - how do I switch it off?!!

Edit:

I should also point out, if you open Excel in safe mode, it behaves normally, snapping to the correct cell immediately, and producing the results immediately. But I guess safe mode is also disabling a few things I need, such as the Acrobat tab.

 

[Anchundan]

For anyone interested, I think I've solved this, by going to Start - typing 'advanced system', going into Performance settings, and un-checking 'Animate controls and elements inside windows'.

 

[Mattus]

Yeah, Excel 2013 does this. Doesn't bother me too much but it's beyond me why Microsoft is trying to consumerise everything. I can't imagine why anyone who uses Excel for work would want a load of silly animations.

 

[Caged]

Microsoft are floundering around trying to work out what their target market is, and make bad software in the interim.

 

[Grrrrr]

Figuring out how to turn off those damn animations was the first thing I did after installing 2013!

 

[bledd]

Does seem a backwards step not being able to open Word or Excel into a blank new document within a second of launching.

 

[bad_ass_neil]

I have hated this set-up in outlook 2013 and switching from mail to calendar and it being slow, that option fixed it as well

 

[Deehjay]

My PowerPoint goes slow whenever I paste large images and downscale them for some reason. Have to switch between different slides multiple times before it goes back to normal

 

[james.miller]

its just an animation, doesnt really affect the time it takes from clicking on a cell and that cell becoming available to edit at all.

For anyone interested, I think I've solved this, by going to Start - typing 'advanced system', going into Performance settings, and un-checking 'Animate controls and elements inside windows'.

Id rather not turn everything off in windows just for excel

 

[JWingfield]

I had same issue, resolved very nicely with this little registry change:-

[HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Graphics]
"DisableAnimations"=dword:00000001

 

[Anchundan]

For anyone interested, I think I've solved this, by going to Start - typing 'advanced system', going into Performance settings, and un-checking 'Animate controls and elements inside windows'.

I've never quoted myself before, feels quite strange!

I can't figure out how to do this in Windows 10 - does anyone know how to stop animations in Win10?

 

[russell664]

Yeah, Excel 2013 does this. Doesn't bother me too much but it's beyond me why Microsoft is trying to consumerise everything. I can't imagine why anyone who uses Excel for work would want a load of silly animations.

This.

I work in Excel, Access every single day, and the animations do not help my productivity at all!

 

[Whoop]

I've never quoted myself before, feels quite strange!

I can't figure out how to do this in Windows 10 - does anyone know how to stop animations in Win10?

It's still there, either search for Control Panel on the Start Menu and go System>Advanced or you could use the keyboard shortcut - Windows Key + Pause/break to get straight to system.

 

[Anchundan]

Brilliant, thanks!

 

[james.miller]

Excel 2007+ supports more than 64k rows, for a start. They have loads of improvements.

 

[holygamer]

Who needs 64K of rows? What other improvements are there?

 

[james.miller]

Who needs 64K of rows? What other improvements are there?

Anyone who uses spreadsheets for any proper data analysis? If you want a list of improvements I'm sure MS have a comparison chart.

 

[Aod]

Who needs 64K of rows? What other improvements are there?

Back in Uni when I used Excel all the time, I had one workbook that was over 50MB, more than 100,000 rows etc. It happens often.