rank formula not displaying results

[bugdout]

hi everyone - I have been working on a workbook (thanks for helping me out southward!!), but my rank formula results are not displaying when the workbook is enabled. does anyone have any idea why this is ocurring, and how to fix it??? HELP!!

[Gatti]

Hi!

Could you please attach a Workbook, instead a Word Doc?

Thanks!

[bugdout]

here is the workbook. when it's updated/enabled the rank results do not display. any ideas?

[bugdout]

Hi Gatti, did you ever findout why the cells are blank (not returning the results) until clicking on the cell? Is there a difference between EXCEL 2007 and 2010?

[Jonmo1]

I would assume they're returing "" because the IFERROR is trapping an error.
When I remove IFERROR form a formula in say AB52, I get #Value! Error

When I run the evaluation tool on the formula, it shows ?Name! error on the EVAL function.

What is EVAL ??

[bugdout]

eval- used to turn a string of text into an array. basically, trying to use it to sort the data to self populate the break schedule. it works in excel 2007, but not in my 2010. not sure why, they are not that different. if I don't enable it it works fine. any ideas?

[JohnTopley]

Does this help ..???

http://www.myonlinetraininghub.com/e...luate-function

[bugdout]

not really, not an expert. the spreadsheet has named ranges etc. I don't understand why it works in 2007 and not 2010. when i open it in 2007 (without enable) it looks fine, break scheules auto popultaes etc the way it should. but once I enable it, the cells don't show the results so the break schedules do not populate. any ideas what would cause this? see the attached file (without any links - its been updated).