Why does TransferSpreadsheet (acImport) import data which does not exist in the workbook?

I have a spreadsheet which consists of a pivot table only. I want the data out of the pivot table, so I drill to details, delete the pivot table sheet entirely and save the book with just one sheet showing details of about 15 colums and 23k rows. I want to be clear, there are NO other sheets in the workbook!

However,  when I try to import using VBA this particular sheet does not import the data within it. Instead, 3 columns are imported "Calculated Field", F1 and F2. They are the columns which would show up if you were to select Show Formula fields from the Pivot table menu. I can see the formulas from the pivot table in them. I don't understand this! The pivot table doesn't exist. There is no way to get to those formulas. I deleted them and only have the details sheet in the workbook. Here is the code I'm using to import the workbook:

Public Function ImportData()
Dim xl As Object

Set xl = CreateObject("Excel.Application")

xl.Visible = True
IgnoreRemoteRequests = True
xl.DisplayAlerts = False
xl.Workbooks.Open "C:\Import_SiteMaster\Master_Metrics.xls"

'note: Right here if I pause to look at the spreadsheet, the active sheet is showing my 23k rows

DoCmd.TransferSpreadsheet (acImport), acSpreadsheetTypeExcel9, "Conv_Master_Metrics", _
"C:\Import_SiteMaster\Master_Metrics.xls", True

xl.Workbooks.Close
xl.Quit

'the 23k rows are not imported. Only the formula definition sheet!!! arggg!!!!

End FunctionStart Free Trial