+ Reply to Thread
Results 1 to 2 of 2

Excel Power Pivot Using Access Database Files

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    u.s.a
    MS-Off Ver
    excel 2010
    Posts
    33

    Excel Power Pivot Using Access Database Files

    Hi,

    I have a project at work that I really need help with. The file uses PowerPivot by bringing in five different Access Database files. I believe this is done by updating the data connections in PowerPivot. However, I don't understand how all the different reports are connected to ultimately create a final consolidated pivot / report / analysis. These reports have different fields and headings but each report has at least one field that is exactly the same (a unique identifier). Can you show me how the reports or tables are connected? I believe keys were setup from each of the reports. It's really hard for me to explain so i was wondering would it be possible to get on TeamViewer so that i can show someone and get some help? I'd really appreciate it. Thank you so much.

    Regards,
    Tawny

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Excel Power Pivot Using Access Database Files

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Power Pivot - links to excel files as source not recognized
    By Marionetto in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-15-2019, 10:05 AM
  2. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  3. Would an Access database be useful to convert to from Excel files?
    By ziggyztz in forum Access Tables & Databases
    Replies: 8
    Last Post: 11-14-2015, 09:15 PM
  4. Excel power view with access database
    By udrizwow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-09-2015, 08:20 AM
  5. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  6. Import many excel files to many tables in one access database
    By boss1982 in forum Access Tables & Databases
    Replies: 3
    Last Post: 12-26-2012, 04:05 PM
  7. [SOLVED] VBA Code to create PIVOT in Excel from access database
    By ST in forum Excel General
    Replies: 1
    Last Post: 07-26-2006, 01:45 PM

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