Hi all,
I have been working on producing a report for some time now, and when i think I finally have it completed it doesn't seem to work.
I have saved a template of my report so that I can input new raw data. I have just tried to do this to be confronted with the error message: "Excel ran out of resources while trying to calculate one or more formulas. As a result these formulas cannot be evaluated"
I have managed to return the correct answer by highlighting an individual cell, clicking on the formula in the formula bar, pressing enter and then okay when the above message is shown. Once done the cell is populated with the correct answer for that given formula. Problem is my report has hundreds of formula so this isn't exactly ideal
Please can someone help me out?
Kind regards,
Marc
I have been working on producing a report for some time now, and when i think I finally have it completed it doesn't seem to work.
I have saved a template of my report so that I can input new raw data. I have just tried to do this to be confronted with the error message: "Excel ran out of resources while trying to calculate one or more formulas. As a result these formulas cannot be evaluated"
I have managed to return the correct answer by highlighting an individual cell, clicking on the formula in the formula bar, pressing enter and then okay when the above message is shown. Once done the cell is populated with the correct answer for that given formula. Problem is my report has hundreds of formula so this isn't exactly ideal
Please can someone help me out?
Kind regards,
Marc