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.

Please Login or Register  to view this content.

in 5 sheets
2.

Please Login or Register  to view this content.

in 70 sheets
3.

Please Login or Register  to view this content.

in one sheet but 5000 rows
4.

Please Login or Register  to view this content.

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 ...