Why does this error out on the line shown below in red?

[aresquare1]

I need to copy a date from a Master pricing table on the C drive to warn management when the salesmen didn't have the most current data and want to copy the date on the master table as the workbook opens.
------------------
Private Sub Workbook_Open()

Master_Table_Date

End Sub


Private Sub Master_Table_Date()

Application.ScreenUpdating = False


'Enter Last_Update date from Master Table as it Opens (Mitch, I move to the right sheet, then to the right cell then I want to enter the date from a file on the C drive.)
Sheets("Output").Select
Range("Master_Date").Select
ActiveCell.FormulaR1C1 = "='C:\Users\Public\Documents\Prospect Pricing Tables.xlsx'!Last_Update"
Range("A1").Select

End Sub

[Pauleyb]

First, I believe you need square brackets around the file name. Second, either you don't have a sheet name or a range. I'm thinking you are pointing it to a sheet named Last_Update, but that is not a formula. You need a range or a cell name such as R1C1.
='[Filename]Sheetname'!CellReference