I have a sheet with three columns that on entering a value in USD
automatically calculates the GBP and EUR values based on a reference
list of rates on another sheet.

My problem is that when I update the rates I don't want any
historically entered information to be updated, only new entries.

Is this possible?