CODEWITHSUNDEEP
excelexcel-formula
صبا اسماعیلی
صبا اسماعیلی

Reputation: 3

How can I limit excel recalculations?

I’ve got a somewhat big excel file (around 300 MB) with various sheets which takes VERY LONG to recalculate on my office computer every time I change something.

I know I can limit calculations to sheets, but I’m looking for a way to limit them to ranges. I’d rather excel to only recalculate a certain column or maybe a certain range in a table.

Upvotes: 0

Views: 64

Answers (1)

Senior Momentum
Senior Momentum

Reputation: 196

You can do it in VBA.

Sub CalcRange()
    Dim rg As Range
    Set rg = Selection
    rg.Calculate
End Sub

Upvotes: 1

Related Questions