Perhaps it is because your shift lock is on <g

Try:

Tools Options Calculations

Is Manual selected? If so select Automatic

Manual/Automatic is automtically set from the first spreadsheet that you
open and does not change when you open another spreadsheet with different
calculation set.


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk
"DAVE" wrote in message
...
I OPEN SAVED INVOICE CLEAR QTY & PRICES CONTENT TO REGENERATE NEW INVOICE
TO
SAME CUSTOMER. BUT I GET NO AUTOMATIC RECALCULATION
WHY