![how to activate vba in excel 2016 how to activate vba in excel 2016](https://www.techonthenet.com/excel/macros/images/visual_basic_editor2016_002.png)
I assumed that meant that Office 2016 utilized or made available more resources, like memory, to the user - as in larger and more robust workbooks.
![how to activate vba in excel 2016 how to activate vba in excel 2016](https://i.ytimg.com/vi/6ZXR3OKblWw/maxresdefault.jpg)
It might slowdown a bit until they're complete.Ģnd - I miss-interpreted the statement that "Office 2016 uses more system resources then Office 2010". Sure, during background downloads and installs My Excel VBA runs about the same time first thing in the morning and just before I shutdown at night.
#How to activate vba in excel 2016 windows 10
If you need further help please upload your file (maybe with anonymous data) on an online file hoster likeĪ macro to anonymize data in selected cells can be downloaded here:ġst - I have a Windows 10 Office 2010 system, and I don't notice any appreciable slowdown throughout the day. The same is true for Excel (and almost any program on your PC), if you compare an old Excel and the newest, you can see a lot of security options, colors, eye catchers. means your PC has to execute more code to accomplish the same things. The reason is that your Windows gets updates, new features. If your arguments are right the system has to run at the same speed as in the first time you switched it on. And why would the Office community think that its ok for VBA codes to run slower in succeeding versions of Excel? Why would it run slower because Office 2013/2016 uses more system resources then office 2010.ĭid you already noticed that your own PC slow down with the time? So why?