+ Reply to Thread
Results 1 to 2 of 2

Vlookup & Pivot Table to raw CVS file via Data Connections

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    USA
    Posts
    4

    Vlookup & Pivot Table to raw CVS file via Data Connections

    Issue:

    I have several large CSV files I need to work with. File source is Oracle (10g) Query Exports to Comma Separated Values data file.
    I need Vlookup capability and Pivot Table functionality when working with these files. I receive new data files each business day.

    Rather than open each file, convert to Excel 2007 xlsx format, set up pivot tables and add VLookups each time I get a new file (daily), I want to create a pivot table that connects to the raw CSV file via Data Connections. When I try to connect via Excel 2007 Data Connections I am receiving a message that I can't create a pivot table using data in a csv format.

    Is this correct? Or am I missing an Add-In? Any suggestions on how to do this?

    Attached is a sample data file (limited to the first 100 records).

    Thanks
    joanna.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-18-2008
    Location
    Ipswich, England
    MS-Off Ver
    Office 2007, 2003, 2000, XP
    Posts
    17
    I have experienced the same problem with 2007. The method you describe works perfectly in previous versions, but there seem to be a number of security issues in 2007 concerning external data connections.

    The only work around I have found is to copy and paste the data into an existing XLSX sheet. The look ups then recalculate using the new data. (Assuming the data is the same number of columns and the old data is deleted!).

+ 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. Setup data for Pivot Table
    By Paul7 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2008, 11:46 AM
  2. Refresh Pivot Table Data Not Working Correctly
    By robertguy in forum Excel General
    Replies: 3
    Last Post: 10-01-2007, 09:11 AM
  3. Pivot Table Autofilters Not Clearing On Refresh
    By kkatzer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2007, 01:35 PM
  4. Pivot Table limiting data
    By Publius in forum Excel General
    Replies: 4
    Last Post: 06-01-2007, 02:30 AM
  5. Adding to Pivot Table data range
    By spack in forum Excel General
    Replies: 1
    Last Post: 04-05-2007, 01:04 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