Excel Filter Madness

%3CLINGO-SUB%20id%3D%22lingo-sub-2599716%22%20slang%3D%22en-US%22%3EExcel%20Filter%20Madness%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2599716%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BI'm%20hoping%20one%20of%20you%20geniuses%20can%20help%20me.%26nbsp%3B%20My%20company%20uses%20a%20shared%20Excel%20spreadsheet%20to%20track%20data%20for%20new%20employees%20but%20inevitably%20we%20have%20people%20that%20filter%20data%20that%20throws%20the%20whole%20spreadsheet%20out%20of%20whack%20and%20they%20forget%20to%20revert%20the%20filters%20before%20logging%20out%20and%20the%20changes%20are%20saved.%26nbsp%3B%20Currently%20we%20have%20all%20employees%20filtered%20from%20newest%20hire%20to%20oldest%20and%20we%20just%20want%20to%20revert%20the%20spreadsheet%20back%20to%20the%20date%20they%20were%20entered%20onto%20the%20spreadsheet.%26nbsp%3B%20Is%20there%20a%20way%20to%20get%20this%20accomplished%20without%20going%20back%20in%20the%20version%20history%20and%20selecting%20the%20option%20before%20the%20data%20was%20filtered%3F%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2599716%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2599773%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Filter%20Madness%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2599773%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118716%22%20target%3D%22_blank%22%3E%40Heather_Whiteside%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnless%20the%20worksheet%20contains%20a%20column%20that%20you%20can%20use%20to%20restore%20the%20original%20sort%20order%2C%20there%20is%20no%20way%20to%20reconstruct%20it%20in%20the%20current%20version%2C%20so%20you'll%20have%20to%20go%20back%20to%20a%20previous%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2599792%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Filter%20Madness%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2599792%22%20slang%3D%22en-US%22%3EDarn%2C%20that's%20what%20I%20was%20afraid%20of.%20Thank%20you%20for%20your%20help%2C%20Hans!%3C%2FLINGO-BODY%3E
New Contributor

Hi all, 

     I'm hoping one of you geniuses can help me.  My company uses a shared Excel spreadsheet to track data for new employees but inevitably we have people that filter data that throws the whole spreadsheet out of whack and they forget to revert the filters before logging out and the changes are saved.  Currently we have all employees filtered from newest hire to oldest and we just want to revert the spreadsheet back to the date they were entered onto the spreadsheet.  Is there a way to get this accomplished without going back in the version history and selecting the option before the data was filtered?  Thank you!

2 Replies

@Heather_Whiteside 

Unless the worksheet contains a column that you can use to restore the original sort order, there is no way to reconstruct it in the current version, so you'll have to go back to a previous one.

Darn, that's what I was afraid of. Thank you for your help, Hans!