• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Data Connection

S

sms2luv

Member
Hi,
I am importing pivot table data from a different excel file using data connection.
When I get the data, there are too many things which are not required,
For example, I have several managers listed in the pivot and I only need data for specific manager, is there any option for filtering.
Also when I import data the column headings changes in F series like f1,f2....
 
sms2luv said:
Hi,
I am importing pivot table data from a different excel file using data connection.
When I get the data, there are too many things which are not required,
For example, I have several managers listed in the pivot and I only need data for specific manager, is there any option for filtering.
Also when I import data the column headings changes in F series like f1,f2....
Click to expand...

Attach a sample file, including the pivot you have created - you should be able to filter out the manager very easily, but let's see what your problem is ...
 
due to security reason of my organisation, I m not allowed to upload file.
I have a similar issue, let me explain.

I have a file A, which has a formula of getpivotdata().
The data is pulled up from a different pivot table called B.
When I open file 1 the get pivot data shows value error, but at the same time when I open B file, the results are shown in File A.
In short I mean that the result of getpivotdata is only available when file B is open.

Is there any way I can update the value with opening file B
 
You must log in or register to reply here.
Back
Top