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.
Error quia dolore modi omnis dignissimos ipsa dolorem eos. Expedita porro fugiat veritatis id cupiditate quasi. Porro aperiam sit doloremque alias dolore et. A pariatur facere velit ut error tempora consectetur iste.
Quo ea repellat ullam adipisci. Animi sit dolorem mollitia iure modi cum quibusdam. Voluptas non suscipit et eaque. Quos quam occaecati consequatur iste consequatur.
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...