Creating PivotTable in VB.NET
I've been trying for a while to get a PivotTable generated from another sheet in a Workbook. I'm not completely sure if I'm doing this right, but here's the code that I currently have:

        Dim pivotCache As Excel.PivotCache
        pivotCache = reportWB.PivotCaches.Create(Excel.XlPivotTableSourceType.xlDatabase, WIPsheet.Range("A1:Q30000"), Excel.XlPivotTableVersionList.xlPivotTableVersion12)
        Dim pivotTables As Excel.PivotTables
        pivotTables = StatSheet.PivotTables(misValue)

        Dim QuotesPivot As Excel.PivotTable
        QuotesPivot = pivotTables.Add(pivotCache, StatSheet.Range("A1"), misValue, misValue)

misValue is just System.Reflection.Missing.value

It's coming back with saying:

    The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.

I looked at the SourceData property within the pivotCache variable and it's all just a bunch of System.DBNull values. The data is definitely filled in at this point.
Creating PivotTable in VB.NET
===

I've been trying for a while to get a PivotTable generated from another sheet in a Workbook. I'm not completely sure if I'm doing this right, but here's the code that I currently have:

        Dim pivotCache As Excel.PivotCache
        pivotCache = reportWB.PivotCaches.Create(Excel.XlPivotTableSourceType.xlDatabase, WIPsheet.Range("A1:Q30000"), Excel.XlPivotTableVersionList.xlPivotTableVersion12)
        Dim pivotTables As Excel.PivotTables
        pivotTables = StatSheet.PivotTables(misValue)

        Dim QuotesPivot As Excel.PivotTable
        QuotesPivot = pivotTables.Add(pivotCache, StatSheet.Range("A1"), misValue, misValue)

misValue is just System.Reflection.Missing.value

It's coming back with saying:

    The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.

I looked at the SourceData property within the pivotCache variable and it's all just a bunch of System.DBNull values. The data is definitely filled in at this point.