Grid[{{Abs, Re, Im},
SphericalPlot3D[2 π Sin[θ] #@
SphericalHarmonicY[10, 5, θ, φ], {θ, 0, 2 π}, {φ, 0, 2 π},
PlotStyle -> Opacity[0.3],
PlotPoints -> 40,PlotRange -> All,
Mesh -> {5, 10},MeshStyle -> {Opacity[0.1], Darker@Purple},
Boxed -> False, Axes -> False] & /@ {Abs, Re, Im}},
Frame -> All]

SphericalHarmonicY[100, 50, θ, φ] takes so long time.
SphericalPlot3D[2 π Sin[θ] Abs@
SphericalHarmonicY[100, 50, θ, φ], {θ, 0, 2 π}, {φ, 0, 2 π},
PlotStyle -> Opacity[0.3],PlotPoints -> 150,
PlotRange -> All, Mesh -> {50, 10},
MeshStyle -> {Opacity[0.1], Darker@Purple},
Boxed -> False, Axes -> False]

Sin (theta)should beSin[theta], right? – mickep Nov 05 '14 at 14:51