Is automatic recalculation turned on?

When you alter a QTY what words appear in the status bar (bottom of the Excel
window)? Ready, Calculating, Calculate?


Just to confirm one point. You say that QTY and barcode  are entered manually.
You also say "Rescan a barcode" Is QTY entered at the keyboard and barcode by
scanning?

Are there any macros associated with this workbook? If so do any of those
interfere with what is happening? Is there a macro on the change  event? Is
there a macro which controls the barcode scanning? If so please post the code
so we can understand it ( You will need to copy the code and paste it into the
email as attachments are not allowed on this list.)