So would this be correct?? --
=SERIES('WCM MC'!$A$29:$B$29,'WCM_Monte_Carlo.xls'!rngdates,WCM_Monte_Carlo.xls'!ssninety,6)
Actually, I found that I have to do it this way, but i keep getting an invalid reference error:
=SERIES('[WCM Monte Carlo.xlsm]WCM MC'!$A$29:$B$29,'[WCM Monte Carlo.xlsm]Monte Carlo '!rngdates,'[WCM Monte Carlo.xlsm]Monte Carlo '!ssninety,6)