Appreciate some advice on this ....
I have switched auto-currency update on and it mostly works - for USD, Euro and Pound Sterling - but it does not work for Australian Dollar (AUD) or Candian Dollar (CAD)!
What do I have to do to make this Auto Currency update work for AUD and CAD? I have formatted them the same as USD...Decimal Places: 2 , Symbol Left: $, Code : AUD & CAD respectively. Status is On - of course :-)