Low CPU utilization of Offset function in Excel

Sangwon Son 1 Reputation point
2021-01-27T15:27:36.11+00:00

Hello,

I'm using a high-end multi-core CPU and office 365. Offset functions are used about 4 million times in an Excel file with "height" argument varying from 1 to 45,000.
Previously, even when the height argument is 45,000, the calculation didn't take more than 30 minutes as Excel increased CPU utilization up to 100%.
However, currently, it takes so long due to low CPU utilization for big value. This problem appeared in the same file since sometime in 2020.

In more detail, currently, when the hight parameter is less than 512, then the CPU utilization still increases up to 100% so the calculation is fast.
However, for 512 or more, the CPU utilization doesn't increase and stay low, less than 20% and, in result, the calculation takes very long.

Anyone knows why this change happened? and how to increase CPU utilization again for height parameter of 512 or more?
Actually, I suspect some office 365 update caused this.. because it worked previously but not anymore since some time.
I also tested in Excel of office 2013 and 2013 Excel increased CPU utilization up to 100% for the value of 512 or more.

I'll really appreciate if you help on this matter.

Thanks.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,661 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erin Ding-MSFT 4,456 Reputation points
    2021-01-28T07:42:29.477+00:00

    @Sangwon Son

    Please tell me the version of your Office.
    You could go to File>Account>About Excel.
    61240-1.png

    Generally, it is recommended to use 64-bit Office rather than 32-bit Office since 64-bit Office can access more memory than 32-bit Office.

    Are there any cells that contains formula in the range returned with OFFSET function?
    If yes, please remove the formula to have a check.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.