Formulas Showing, How to Mass Activate?

[Dudibob]

Hi all,

I created a load of formulas via the concatenate formula but now I have 500 x 5 formulas not activating. If I click on each one and enter they work fine but I have to do this individually, is there any way to automate this?

Small sample of the formulas in question:

=IF(LEN(INDIRECT("'"&$A$2&"'!a10"))>0,INDIRECT("'"&$A$2&"'!a10"),"") <tbody> </tbody>	=IF(LEN(INDIRECT("'"&$A$2&"'!b10"))>0,INDIRECT("'"&$A$2&"'!b10"),"") <tbody> </tbody>
=IF(LEN(INDIRECT("'"&$A$2&"'!a11"))>0,INDIRECT("'"&$A$2&"'!a11"),"") <tbody> </tbody>	=IF(LEN(INDIRECT("'"&$A$2&"'!b11"))>0,INDIRECT("'"&$A$2&"'!b11"),"") <tbody> </tbody>

<tbody>
</tbody>

 

[Momentman]

Just a quick question, is your calculation mode set to manual or automatic?

 

[Dudibob]

It is currently set to automatic.