I have two users casuing me a Excel Filtering headache please help.

User A Filters a spreadsheet and saves it
User A only sees the filtered data
User A copies and pastes it into Word
User A sees the same spreadsheet FILTERED in Word

User B opens the same spreadsheet, but it appears UNFILTERED on her PC
User B Filters the same spreadsheet, then copies and pastes it into Word
User B sees the same spreadsheet UNFILTERED in Word

It looks like User B's PC is automatically unfiltering data

How do I make User B's PC behave the same as User A ?