I agree bad code can run poorly, but that is not the issue causing me pain. Uninstalled 32-bit/re-installed 64-bit Office 365 Ran in Normal view (was not in Page Layout) Laptop 2 = 24 seconds per iteration no additional programs open or running, freezes system hard to believe) noticed slower operation of other programs, no change in performance of macro with other programs open Laptop 1 = 11 seconds per iteration Outlook, multiple Excel files open, Teams chat, Teams meeting, 3 sessions File Explorer, 2 sessions Chrome (multiple/many tabs each), has not rebooted in over a week (I know. Running the same file, same macro on both machinesġ.5M+ calculations per iteration (cell formulas), 7 output cells No matter what change on Laptop 2 (problematic machine), iteration time was unchanged. I have run the same file/macro on 2 machines, details below. I have read a lot of threads and tried all of the suggestions but no change in performance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |