![]() ![]() The general concept is called "Optimization" (you can google for it). In addition to using multiple cores there are a number of things you can do to make your spreadsheets more efficient, aka "run faster". MS defaults to installing 32 bit, which is limited to using max 2GB of RAM. ![]() In order for it to take advantage of the RAM you must be using 64 bit Office. Your hardware is certainly up to the job. This article is a report of an investigation into the multithreading capability of Excel 2007 There are techniques you can use to "encourage" VBA to use multiple threads (google is your friend.) Note: "Hyperthreading" can split a physical cpu core into 2 logical cores so the number of cores reported may be double what you expect. When that is on, make sure that the "Use all processors. Make sure "enable multi-threaded calculation" is turned on. But it also depends on how your code and functions are written.įile menu > Options command > Advanced option > Formulas section. Excel is set by default to use all cores it can. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |