Make model faster: convert formulas to text and then back to formulas

Hi all,

I am building a model which is becoming extremely slow, every update to the calculations takes c 30 seconds to compute.

I've identified the problem and believe there could be a good solution to this by converting some formulas to text and then back to formulas again.

Between the sheets "Start" and "End" there are sheets numbered 1-30 with a lot of calculations on each sheet. They are built exactly the same however - meaning if I would copy the entire sheet from sheet 1 and paste it to sheet 3 for example, the formulas would copy paste correctly onto sheet 3.

Let's say I would only want the formulas for sheet 5 to work, and for all the other sheets numbered 1-30 (excl 5 of course) the values would be copy pasted to text values. By doing this the model works much faster and I can do changes that affect sheet 5 in isolation.
When I'm done doing these changes to sheet 5 I want the formulas the be "revived" on the other sheets. If the macro could just copy paste the entire sheet formulas from sheet 5 onto all other sheets 1-30 (located between sheet "Start" and "End"), the model would be restored to it's proper functioning, albeit slower again.

The point of this would be to "freeze" the numbered sheets I'm not interested in reviewing and making the model only recalculating the formulas on one sheet at a time (there needs to be a way of telling the macro which sheet to be isolated. They are named 1-30 accompanied by names. So only the first letter of each sheet name is a number from 1-30)

Hopefully this makes sense and I hope any of you have a smart solution to this!

Thanks a lot!

/Lucas

Thanks for your reply. That's great!

I'm really new to coding, how do I practically implement that? And making sure I know which sheet to target?

THanks

Thanks Rorya.

Only thing is I don't want all other sheets to not calculate, only the sheets between "Start" and "End" numbered 1-30 (apart from the sheet specifically requested to do the calculations).

There is a summary sheet where inputs to the numbered sheets can be made, on to which I would prefer to have the option to choose for example Sheet 5 within that range to still be calculated, whereas the other ones to not be.

Does that make sense?

Thanks a lot for your input, very valued!

Let's say on the Summary sheet in cell F2 one could input any number from 1-30.

If I would input 5 then all sheets apart from the 5th sheet between the sheets "Start" and "End" would have their calculations disabled (remember that the sheets are named 1. ExampleName 2. ExampleName 3. ExampleName etc so it has to find the correct numbered sheet by only looking at the first letter for each sheet).

Thanks a lot for your help.

You're a genius, works just like a charm, calc time from 30 s to 5 s!!!

Many thanks for your help, this is great!