You can change the LASTVALUE for an Oracle sequence, by executing an ALTER SEQUENCE command.
For example, if the last value used by the Oracle sequence was 100 and you would like to reset the sequence to serve 225 as the next value.
The alternative is to override the active model's custom update sequence with the default update sequence.
One drawback of using USNs is that administrators can't compare USNs on one domain controller to USNs on other domain controllers.
According to Microsoft, the system for replication was designed with this limit in mind.
Note: To help prevent replacing existing data when you drag the fill handle, ensure the Alert before overwriting cells check box is selected.
If you do not want Excel to display a message about overwriting cells, you can clear this check box.