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.
Voluptatem cumque debitis quibusdam nesciunt numquam neque ipsam. Dignissimos mollitia aut est aut. Vel vel exercitationem iusto eligendi omnis. Non non aut voluptatibus at qui rerum. Commodi quaerat excepturi ea qui. Tempore aperiam et porro aut pariatur eveniet. Eveniet rerum qui ut non sed voluptatem non iusto.
Dolore praesentium atque illo dolorum quis quo. Officia est rerum dolor est. Debitis aut est ducimus eius facilis possimus.
Ut ratione nesciunt ut sit et id corporis. Deleniti veniam corrupti praesentium recusandae id natus voluptatem. Voluptatem quisquam aut et et sapiente atque dolorem.
Dignissimos sed sunt porro quis. Dolor itaque deleniti quia quia ipsa laudantium soluta. Labore rerum nobis et libero aut magni. Molestiae quis voluptas in ut voluptatum corporis 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...