Excel File Open function

%3CLINGO-SUB%20id%3D%22lingo-sub-2987772%22%20slang%3D%22en-US%22%3EExcel%20File%20Open%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2987772%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20some%20guidance.%26nbsp%3B%20Since%20the%20latest%20update%2C%20when%20I%20try%20to%20open%20a%20file%20in%20Excel%20I%20am%20presented%20with%20a%20list%20of%20file%20arranged%20by%20date%2C%20Today%2C%20Last%20Month%2C%20Earlier%20this%20year.%26nbsp%3B%20This%20defeats%20the%20Quick%20Access%20feature%20since%20the%20list%20no%20longer%20shows%20all%20the%20files%20in%20a%20directory%2C%20thus%20making%20me%20go%20to%20File%20Explorer%20to%20identify%20the%20file%20and%20double%20click%20to%20open%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20work%20around%20this%20%22feature%22%20and%20restore%20the%20Excel%20Open%20File%20list%20to%20a%20simple%20directory%20list%20function%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoe%20B.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2987772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2988258%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20File%20Open%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2988258%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425973%22%20target%3D%22_blank%22%3E%40JoeBusfield%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20File%20%26gt%3B%20Options.%3C%2FP%3E%0A%3CP%3ESelect%20Save%20in%20the%20navigation%20pane%20on%20the%20left.%3C%2FP%3E%0A%3CP%3ETick%20the%20check%20box%20%22Don't%20show%20the%20backstage%20when%20opening%20or%20saving%20files%20with%20keyboard%20shortcuts%22.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%0A%3CP%3EUse%20Ctrl%2BO%20or%20click%20the%20Open%20button%20on%20the%20Quick%20Access%20Toolbar%20to%20open%20files.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Looking for some guidance.  Since the latest update, when I try to open a file in Excel I am presented with a list of file arranged by date, Today, Last Month, Earlier this year.  This defeats the Quick Access feature since the list no longer shows all the files in a directory, thus making me go to File Explorer to identify the file and double click to open in Excel.

 

Is there any way to work around this "feature" and restore the Excel Open File list to a simple directory list function?

 

Thanks for your advice.

 

Joe B.

3 Replies

@JoeBusfield 

Select File > Options.

Select Save in the navigation pane on the left.

Tick the check box "Don't show the backstage when opening or saving files with keyboard shortcuts".

Click OK.

Use Ctrl+O or click the Open button on the Quick Access Toolbar to open files.

@Hans Vogelaar 

Thanks Hans.  There was no change in the file listing after I followed your guidance, but trying to open a file still showed files by date open rather than a simple listing:

JoeBusfield_0-1637714984691.png

An enhanced feature that is less than useful to me.

Found it!! Right clicking in an empty space of the file list presented a menu with a "Group" item. Selected "None" and the file listing returned to what I am used to seeing!