I am using a tab of a spreadsheet as a data source. Many of the fields on it were created by macros that brought fields over from another tab and from formulas. It has clearly defined Header names on the first row. When I select this spreadsheet as a data source, the next option is to select the data representation of the headers. My only option is to rename the headers and not use the headers already defined in the spreadsheet even though they appear in the display box of that step. After going through the setup process and attempting to create a pivot table, I still do not have the option of using the already defined headers.
Does anyone know why this is happening and know anyone of correcting this?