I have a macro that I run which has some VLOOKUP formulas (coding is below):

ActiveCell.FormulaR1C1 = _
"=IF(RC[-2]=""walmart"",VLOOKUP(RC[-7],'[Walmart Price list.xlsx]WALMART'!C2:C10,9,FALSE),IF(RC[-2]=""Belk"",VLOOKUP(RC[-7],'[Walmart Price list.xlsx]BELK'!C12:C13,2,FALSE),IF(RC[-2]=""sears"",VLOOKUP(RC[-7],'[Walmart Price list.xlsx]SEARSKMART'!C2:C10,9,FALSE),IF(RC[-2]=""kmart"",VLOOKUP(RC[-7],'[Walmart Price list.xlsx]SEARSKMART'!C2:C10,9,FALSE),IF(RC[-2]=""thehom" & _
"edepot"",VLOOKUP(RC[-7],'[Walmart Price list.xlsx]HD'!C2:C10,9,FALSE),IF(RC[-2]=""shopko"",VLOOKUP(RC[-7],'[Walmart Price list.xlsx]SHOPKO'!C2:C10,9,FALSE),IF(RC[-2]=""bluestem"",VLOOKUP(RC[-7],'[Walmart Price list.xlsx]BLUESTEM'!C2:C10,9,FALSE),IF(RC[-2]=""jcpenney"",VLOOKUP(RC[-6],'[Walmart Price list.xlsx]JCPENNY'!C17:C20,4,FALSE),IF(RC[-2]=""lowes"",VLOOKUP(RC[-" & _
"7],'[Walmart Price list.xlsx]LOWES'!C1:C2,2,FALSE))))))))))" & _
""

Every time I run the macro it asks me to "Update Values: Walmart Price List". I'm referencing the same sheet every time, so why does it keep asking for updates? It's not a big issue to point it in the right direction every time, but I would rather not have to.