Share via

Data Connection not pulling all data in excel

Anonymous
2018-06-27T14:18:21+00:00

Help me on this please....

I created an external data connection using excel 2016 and created a pivot table to pull the data.

All things are good when I noticed on some filter using slicer that some data are not pulling correctly, it displays blank but is should have. I doubled check the data itself and filtered it manually and yes it has data. I don't know what happen but I tried to re create a data connection it still display blank data. please see and compare my pivot table result:

Pivot table using data connection:

Pivot table without data connection:

This should be the result, I already tried to REFRESH ALL the data and still the same.

Your help is much appreciate.

Thanks!

aReOhwhY

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-06-30T04:08:41+00:00

    I sent you a private message so you can send your reply on it. To check, kindly click the mail icon located at the top-right corner of the forum window. Refer to the screenshot below:

    I'll be waiting for you message so we can resolve this issue together.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-06-29T12:25:33+00:00

    I don't see that features on my end... :-(

    I don't know if I'm doing it right.... btw, the spreadsheet are at my work and I'm not able to send to any uploading sites.

    Thanks!

    ~aReOhwhY

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-06-29T09:45:17+00:00

    Please send the files via private message on this forum. The option to send you an email on the email address provided is not available as of the moment. Kindly refer to the screenshot posted below to know how to send a private message:

    We'll wait for your message so we can resolve this issue.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-06-28T12:17:00+00:00

    yes please, contact me here at my yahoo email *** email address was removed for privacy ***.

    Thanks so much!

    *** Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy. ***

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-06-28T04:57:05+00:00

    Hi aReOhwhY,

    I would like to investigate this issue. For us to get a better picture of the issue, can you send us the files thru a private message? We need it so we can find the best resolution to this problem.

    We will be waiting for the files to be sent via private message.

    Was this answer helpful?

    0 comments