Updating Links

[JAKEFULLER]

I have this formula:

=IF(K92="0","0",IF(K92="","0",IF(C92="","0",IF(K92="","0",IF(LEFT(E92,2)="DD",2*VLOOKUP(C92,'[PRICING.xlsx]worksheet'!$A:$I,4,FALSE),VLOOKUP(C92,'[PRICING.xlsx]worksheet'!$A:$I,4,FALSE))))))

this formula uses vlookup to lookup a price table and give me the price of an item. I update the price table about once a week.

the problem is, when i use the spreadsheet and save it, i want it to keep the price in the spreadsheet that it looks up. but everytime i update prices, all of my spreadsheets automatically get updated. this happens even if i go to data - edit links, and choose to prompt the user to update links, it automatically updates them each time.

so, i price something and save the spreadsheet. then i update the pricing table. the next time i open up that pricing spreadsheet, everything is automatically updated.

can anyone help?

[hoyasaxa215]

In the Advanced options menu, you can uncheck the box that says "Update links to other documents" and make sure "Save external link values" is checked.

[JAKEFULLER]

when i reopen the spreadsheet with the formula, that box is checked again.