EXCEL RECENT DOCUMENTS NOT SHOWING PC

Instead of the flat grey push pin, thereвЂ™s a vertical green push pin. In the screen shot below, the ProjectWorkCurrent.xlsm file is pinned to the list. (Maybe thatвЂ™s why itвЂ™s call the Recent Documents list!) Now I use it quite often, to вЂњstickвЂќ files that IвЂ™m working with for a few days. This is another one of the Excel 2007 features that I didnвЂ™t notice until recently. To keep a file on the list, click that push pin, to activate it. In Excel 2007, thereвЂ™s a push pin icon at the right of each file name. Normally, the older items in the list drop off the bottom, as new files are opened. In Excel 2003, you can also remove the check mark from the Recently Used File List setting.ДЄfter the list is cleared, you can change the setting to a higher number, to start building the list again. In either version of Excel, you can clear the list, by changing the number to zero. Click OK, to close the Option dialog box.On the General tab, change the number for the Recently Used File List.In Excel 2003, the maximum number of files you can show in the list is 9. I also do not know how long these files have been showing up in Excel as recently opened, this was the first day that he had noticed it. I cannot verify that he did not in fact open these files at some point in time and has just forgotten.

EXCEL RECENT DOCUMENTS NOT SHOWING PC

The maximum number of files is 50, but that many might not show unless you have a really tall monitor. The PC has been used by this user since it was new, and is roughly 2 years old.

Click OK, to close the Excel Options window.

In the Display section, change the number for Show this number of Recent Documents.

Click the Office Button, then click the Excel Options button.

Instead of leaving the default setting, you can show more or fewer files. My Recent Documents List was showing 17 files, and I guess thatвЂ™s the default number, since I donвЂ™t remember changing it. Click on file name, to open that file again. In Excel 2007, if you click the Office Button, you can see a list of documents that youвЂ™ve opened recently.

The files I open and save now, seem to retain the correct date/time when saved but there is a window from August 8th to date where my recent files are either missing OR display the incorrect date/time.You open lots of Excel files every day, and sometimes open the same file several times. The September file, 20180904_Apportioning_IT.xlsx doesn't show in my recent workbooks at all. I create one of these 'Apportioning' sheets every month, using the previous months' sheet as a foundation. I now suspect that the problem is actually the date/times displayed for documents rather than the retention in Excel.ДЄs an example, take a look at the 'Older' list above.Дў0180808_Apportioning_IT.xlsx was last updated on September 4th but displays 10:29Дў0180709_Apportioning_IT.xlsx was last updated on July 9th but displays 10:27 I opened that sheet and saved it and now the correct date/time is displayed. The document was actually last updated on September 19th. Looking in my 'Pinned' section though, the 2nd sheet down is a document that gets updated regularly - and yet the date/time shows as August 7th. 'Yesterday' shows the only other spreadsheet I worked on yesterday and 'This week' shows a file I created on Tuesday. I opened a file from my network share (U drive is mapped to a networked file store) which you can see listed under 'Today' alongside a local file IO have been working on this week. When I reverted back to the original key, I see this:

Excel recent documents not showing