Excel Calculating Processor stuck on 0% not updating?

[Imran Magsi]

Hi Guys!

I have a excel file in which i have around 70 Sheets all sheets data is depending on one main sheet which have 9000 rows. it was working perfect but today i have add if function in around 2000 rows after it its not updating the Calculating Processor stuck on 0%. i was working this file since last month and i have to submit data today please guide me.

[FDibbins]

What formulas are you using?

If you are using full-column ranges, adjust to cover just the range you need

[lcartwright]

Not sure if this is helpful, but just double check that the auto calculation is turned on (Excel 2010):

File>Options>Formulas +check that the radio button for "Automatic" is selected.

[Imran Magsi]

i am using lot of formulas like
1.

=SUMPRODUCT(SUMIF(INDIRECT("'"&SELF&"'!B7:B61"),$B7,INDIRECT("'"&SELF&"'!D7:D61 ")))

in 5 sheets
2.

{=IFERROR((VLOOKUP($B$1&$B15&$D$1,CHOOSE({1,2},Centers&Services&Years,January),2,0)),"0")}

in 70 sheets
3.

=IF(D356="2013", Q356/12,IF(D356="2014", Q356/12,IF(D356="2015", Q356/12,IF(D356="2016", Q356/4,IF(D356="2017", Q356/12, Q356/12)))))

in one sheet but 5000 rows
4.

=IF(ROUND((SUM(R360)/1),-1)>200,"200",ROUND((SUM(R360)/1),-1))

in sheet but 7000 rows

[FDibbins]

I dont see anything obviously processor-intensive there.

Do you have any formulas based on old/historic data? If so, consider valuing those formulas

[Imran Magsi]

Finally its working but very very slow ...