>... the macro does not record the steps where you are prompted to save space by linking to another sheet. Anyone know what the macro code is to establish this link?


I think I know Excel pretty well, but I have never done anything with pivot tables. Looking at some books I have, they don't look like a lot of fun. Although I don't have the answer, I do see something you might want to read up on in the help screens. Does your recorded macro have "SourceType:" and "SourceData:" in it? I would think that would be where the link is. This is in some sample code in one of my books:

ActiveSheet.PivotTableWizard _
    SourceType:=xlDatabase, _
    SourceData:="'Company both'!R1C1:R145C7", _
    TableName:"Sales&Trans"

Another book I have shows SourceType and SourceData being used with "PivotCaches.Add". You might want to look at that too.

HIH