I have a six sheet workbook. Four of the sheets have some multi-critera VLOOKUP formulas and one of them has less then 500 rows of data but three IF formulas per row.
I turned off the auto calc to add some data to main sheet b/c it would take a while for the other sheets to update.
But when I turned the auto calc back on it just sits at 0%. I can manually calc each sheet indivdually and it instantly calcs every sheet.
Using F9 doens't work either. If I leave it to calc before saving Excel locks up.
I tried removing the IF formulas and it still sticks at 0%.
HELP!!! Please...
I turned off the auto calc to add some data to main sheet b/c it would take a while for the other sheets to update.
But when I turned the auto calc back on it just sits at 0%. I can manually calc each sheet indivdually and it instantly calcs every sheet.
Using F9 doens't work either. If I leave it to calc before saving Excel locks up.
I tried removing the IF formulas and it still sticks at 0%.
HELP!!! Please...