CALCULATE SALES PRICES ON OLD INVOICES

[DAVE]

I OPEN SAVED INVOICE CLEAR QTY & PRICES CONTENT TO REGENERATE NEW INVOICE TO
SAME CUSTOMER. BUT I GET NO AUTOMATIC RECALCULATION
WHY

[Sandy Mann]

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
[email protected]
Replace@mailinator with @tiscali.co.uk
"DAVE" <[email protected]> wrote in message
news:[email protected]...
>I OPEN SAVED INVOICE CLEAR QTY & PRICES CONTENT TO REGENERATE NEW INVOICE
>TO
> SAME CUSTOMER. BUT I GET NO AUTOMATIC RECALCULATION
> WHY