Excel 2016 on Mac. Keeping previous data in a cell. Last updated December 7, 2018 Views 47 Applies to: Excel / Mac /. To do that, click on the letter F at the top of column F to select the entire column. Then press command-1 to open the Format Cells dialog. In the dialog, choose a format. In this case, I think Accounting format is the. Open Microsoft User Data, and then open Office 2011 AutoRecovery. On the Edit menu, click Select All. Drag all files into 'New Folder' on the desktop. The AutoRecovery folder should be empty. Open Excel for Mac 2011 and try to save a file. If you can save a file, review the contents of 'New Folder' to decide which files that you want to keep.

How to Open Newest File in a Folder in Microsoft Excel

In case you want a VBA code which will allow you to open the recently saved file in the folder with just a click on macro button.

Question): I have a team of 10 people & I am urgently looking for a macro that will help me in opening the latest file saved by team member so that I do not have to go the path wherein the file is saved.

We need to follow the below steps:

• Click on Developer tab
• From Code group, select Visual Basic

• Enter the following code in the worksheet module

Option Explicit

Sub NewestFile()

Dim MyPath As String

Dim MyFile As String

Dim LatestFile As String

Dim LatestDate As Date

Dim LMD As Date

MyPath = 'C:UsersDocuments'

If Right(MyPath, 1) <> ' Then MyPath = MyPath & '

MyFile = Dir(MyPath & '*.xls', vbNormal)

If Len(MyFile) = 0 Then

MsgBox 'No files were found..', vbExclamation

Exit Sub

End If

Do While Len(MyFile) > 0

LMD = FileDateTime(MyPath & MyFile)

If LMD > LatestDate Then

LatestFile = MyFile

LatestDate = LMD

End If

MyFile = Dir

Binary option signal app for mac. Loop

Workbooks.Open MyPath & LatestFile

End Sub

In this way, using macro code, we will be able to open the latest file saved by the team member.