Silly question – is there a pivot table in my excel spreadsheet?

[ge-or-ge]

I have inherited a simple excel spreadsheet that connects to an Oracle DB and dumps it to what looks like a pivot table (it has drop down menus with each column).


If there is indeed a pivot table in my spreadsheet, how do I edit it using Excel GUI? I tried Pivot Table toolbar, but it doesn’t pick up any information about any pivot table. For example, all items under Pivot Table > Formulas are grayed out. At the same time, I can add a pivot table to this spreadsheet.


BTW, I can see the SQL query in the xml code, so I can edit the (Tools > Macro > Microsoft Script Editor)


Any help is appreciated.

 

[Luke M]

You could run this macro to see how many, if any, PivotTables you have.

[pre]

Sub PivotTableCheck()
Dim xCount As Integer
xCount = ActiveWorkbook.PivotCaches.Count
MsgBox "PivotTable(s) in this workbook: " & xCount, vbOKOnly, "PivotTable Count"
End Sub

[/pre]

 

[ge-or-ge]

Thank you Luke M. It shows 0. I am new to Excel and I mixed up Pivot Table with drop down lists.

 

[Luke M]

You're welcome ge-or-ge.

Feel free to come back and ask us any questions, we love to help. =)