The formula below is linked to another workbook. How come whenever I copy this formula to a new cell I recieve the Update values prompt which allows me to select and click open the Corporate Actions file. Is there a way around this so that the formula will just copy smoothly wherever I would like it to?
=IF(BZ59="","",VLOOKUP('Live Trades'!BZ59,'\\RandallHudgins\Users\bloomberg\Desktop\SHARE\Analyst Recommendations\Corporate Actions\[Corporate Actions.xlsm]Corporate Actions'!$A6:$I$200,9,))
can anyone help?
It shouldn't ask you unless excel cannot find the file. This happens when you've changed the name of the file or changed its location, or if you've deleted (or edited the tab name of) the worksheet the formula is referring to.
Just ensure that the file Corporate Actions.xlsm and worksheet (sheet tab) Corporate Actions remain where the formula is referring them to.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
I agree but the strange thing is that if I press Cancel then the vlookup function calculates properly. Strange...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks