You routinely open the same six workbooks. The File menu shows only the last four workbooks that you opened or saved. It sure would be nice if it showed at least the last six workbooks. Use Tools –> Options –> General and select the number of recently used files for it to show.
You can increase the Recently Used File List from four to nine workbooks.
Go to Tools –> Options.
From the Option dialog box, choose the General.
Use the spin button to dial the Recently Used File List from 4 to 9.
Immediately after changing the value, your list may only show four files. You have to open and close additional files to expand the list.

discuss this topic to forum
