finding PIVOT table data source

[ajd335]

Hi All,
I have a excel sheet , which has pivot table. The data fields are imported from database.The thing is the pivot table are designed by some one else.
The problem is , I don't know how to see which ( View here of database) "view" are used to fetch the data.
How can I see the source data of pivot table...
i will really appreciate if some one can help me up

[ck9663]

You have to check the EXCEL side first and see what the data source is. Table/View name should be there.

-- CK

[ajd335]

You have to check the EXCEL side first and see what the data source is. Table/View name should be there.

-- CK

I tried but dint see anything like that.Can you please kindly provide me some information under which menu I can see that option.

Thanks

[ck9663]

That would be an EXCEL question.

Depending on the VBA script that was used, it could be a macro/VBA (Tools-Macro) or a straight forward Importing of External Data (Data-Import External Data)

Good luck.

-- CK