I know someone on here must know the answer to this....
you know how you F2 into a cell's formula, highlight a cell reference, hit F5 and enter and it automatically jumps to that cell? Then you hit escape and it goes back to the original cell with the formula in it? Well for some reason if I highlight A626 in the formula and hit F5 then Enter it automatically jumps to 626:626... highlighting the entire row... defeats the purpose of what I'm trying to do... which is quickly look at where the formula is coming from.
I don't need any other suggestions on auditing my formulas, I know how to audit them. The question is for this method in particular... anyone know what the fuck is going on here?
I just tried it in Excel 2007 and couldn't duplicate your problem, sorry man.
Excel 2003 here, and I couldn't replicate it either. What gives?
Excel 2007 here, get the same issue: Formula @ A626 is "=C619+E619+G619", in reference I get "WU:WU" if I select C619
I get the same issue in Excel 2007. If you do A619+B619+C619+D619 in A626 and highlight+F5 any other cell besides C619, it works fine, yet C619 sends you to column WU. Very strange, guessing a random program gitch as I can't replicate it with other cells.
^^^ With your formula, I come up with the same problem in Excel 2010. It's only if I select that cell C619.
Weird
type help help and tell them you think its a bloomberg problem..
Haha, yeah, because they're so fucking helpful with Bloomberg problems, they must be able to solve Excel ones as well.
Autem et molestiae repellendus. Odit a commodi vitae aut repellendus nihil magni. Vitae mollitia tempora quis asperiores sit labore porro culpa. Sit ab distinctio quaerat doloribus eum corporis accusantium.
Voluptatem dolorum excepturi quam non atque placeat perspiciatis quia. Dolor mollitia fugit ea totam et.
Consectetur est molestias est id id culpa nihil asperiores. Eos recusandae tenetur quidem quis et sed eaque. Amet ea est nostrum illo. Velit in ut natus voluptas earum ea itaque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...