+ Reply to Thread
Results 1 to 2 of 2

Connecting pivot to external workbook changes cells in data

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    5

    Connecting pivot to external workbook changes cells in data

    Hello all,

    Excel is giving me some problems when I try to create a pivot table in workbook #1 that gets it data from workbook #2. Workbook #2 contains over 11 million cells with data in one sheet. I'm using Office 2010.
    This is what happens with the raw data (top) and after import (bottom):
    \1

    I connect both workbooks through, Data, Connections, Add... and then add the workbook #2 containing the raw data. Everything connects fine but somehow the data that is imported in the background into the pivot in workbook #1 is changed, but not always! 1285,31 becomes 1,29E+16 and 80,00 becomes 80.

    Does anyone have a solution to this problem?

    Thank you in advance!
    Attached Images Attached Images
    Last edited by Excellation86; 02-01-2017 at 11:33 AM.

  2. #2
    Registered User
    Join Date
    02-01-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    5

    Re: Connecting pivot to external workbook changes cells in data

    anyone ?

+ 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. Connecting two macros: Refresh pivot data then export as PDF
    By onemoremile in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2016, 07:54 AM
  2. Replies: 3
    Last Post: 01-09-2015, 06:36 PM
  3. Connecting Pivot Table To Source Data From A Different Workbook
    By bcommando17 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-26-2012, 11:11 AM
  4. Get Pivot Data from External Workbook
    By AmateurXL in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-23-2012, 11:01 AM
  5. Connecting to external Data source
    By Search Dog in forum Excel General
    Replies: 0
    Last Post: 12-28-2011, 12:09 AM
  6. Connecting Source Data from excel workbook
    By dssrun209 in forum Excel General
    Replies: 0
    Last Post: 01-07-2011, 10:46 AM
  7. [SOLVED] Connecting to External Database
    By Geert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2005, 01:06 PM

Tags for this Thread

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