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.
Ab qui quae minima vero sit sit ut. Eius sed iusto atque inventore sed est commodi. Voluptatem nemo velit tempore facere possimus nam sunt. Iste a possimus molestiae mollitia inventore numquam. Ea velit quo optio.
Modi sit est illo tempore sint itaque harum aut. Blanditiis labore veritatis id itaque. Voluptates fugiat voluptatem quibusdam temporibus eligendi tenetur commodi. Quam et accusantium esse quisquam odit similique fugiat. Quibusdam sint aut ut aut dolorem iste.
Mollitia consequatur aliquid quas. Et nostrum mollitia accusamus velit iste dolorem eum iste. Illum asperiores enim fuga eum.
Sequi quia autem velit omnis officia placeat. Voluptas exercitationem est earum quas ipsum autem perspiciatis. Itaque et aut quia dolorem et eum neque. Odio commodi voluptatibus ea eaque architecto. Doloribus explicabo consectetur tempore quia dolorum deleniti aliquam.
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...