The partfamily spreadsheet is only used for the creation of the members and which components they use. It is not telling your assembly (where a member is used) which revision to take.
This functionality comes from the load options.
Ronald van den Broek
Senior Application Engineer
Winterthur Gas & Diesel Ltd
NX9 / TC10.1.2
Building new PLM environment from Scratch using NX12 / TC11