+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Showing Wrong data

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    Wisconsin, USA
    MS-Off Ver
    2016
    Posts
    35

    Pivot Table Showing Wrong data

    Hi,

    So I have a spreadsheet that pulls CSV's from a file folder and compiles them. If I make a pivot table in THAT Workbook it returns values that make sense.... In this case a function of time (.03).

    The problem I am having is that when I am working in another workbook and make a pivot table using that original source data (via a connection) the value is distorted. It shows up as 8772 or some other equally as ridiculous value.

    Anyone have an idea of what is going on here?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Pivot Table Showing Wrong data

    How are you pulling in CSV data?

    Are you using PowerQuery (Get & Transform)? Or via MS Query or some other method?

    CSV is just text file and lacks any schema info, so depending on setting (Registry, Options chosen in Query etc), you may get mixed result.

    If using MS Query/ADO code, I'd recommend use of schema.ini file to enforce schema rule.
    If using PowerQuery, ensure same data type etc are enforced in the editor, and then load to data model.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table not showing data
    By venkiatmaruthi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-18-2016, 11:53 AM
  2. [SOLVED] Pivot Table- Data no longer in table source still showing
    By Smally in forum Excel General
    Replies: 7
    Last Post: 09-10-2014, 11:23 AM
  3. Data not showing in pivot table
    By 4am in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-27-2013, 06:06 PM
  4. Pivot Table not showing all data
    By jmcole in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-27-2013, 08:29 PM
  5. [SOLVED] Pivot table not showing the row of data
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-23-2012, 04:27 PM
  6. Data not showing on Pivot Table
    By la_techie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2012, 06:28 PM
  7. Pivot table showing wrong data (date not month)
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 06:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1