No. R2 is when Microsoft added the ability to name sheets.

Here is a macro you can use to do it after the Excel file has been generated, but it is hardly a good solution.

http://stackoverflow.com/questions/736918/how-to-get-named-excel-sheets-while-exporting-from-ssrs

Put the tab name on the page header or group TableRow1 in your report so that it will appear in the "A1" position on each Excel sheet. Then run this macro in your Excel workbook.

Sub SelectSheet()

For i = 1 To ThisWorkbook.Sheets.Count

mysheet = "Sheet" & i

On Error GoTo 10

Sheets(mysheet).Select

Set Target = Range("A1")

If Target = "" Then Exit Sub

On Error GoTo Badname

ActiveSheet.Name = Left(Target, 31)

GoTo 10

Badname:

MsgBox "Please revise the entry in A1." & Chr(13) _

& "It appears to contain one or more " & Chr(13) _

& "illegal characters." & Chr(13)

Range("A1").Activate

10

Next i

End Sub