+ Reply to Thread
Results 1 to 2 of 2

Excel 2013 and Access 2013 as Pivot Table External Data Source

  1. #1
    Registered User
    Join Date
    04-20-2013
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel 2013 and Access 2013 as Pivot Table External Data Source

    Hello All,

    This is my first time posting, so I'll apologize ahead of time if I'm inadvertantly breaking any posting rules!

    I use Access extensively for housing and modifying data, which I ultimately bring into Excel Pivot Tables as an external data source. This became a problem after I upgraded to Office 2013, which I needed to do to put an Access DB on our SharePont site.

    I was getting the "Wait while Microsoft is configuring Office 2013" each time I opened Access. I researched this and found out it was because I still had Office 2010 components installed. I removed them and it solved that issue. However, I then lost my ability to connect to Access as an external datasource for an Excel Pivot Table. Researching this led me to the current solution of installing the Access 2010 Database drivers, which fixed my connection issue, but Office configures every time I open Access again! Ahhh!

    I will say that I can connect to an Access database remotely if I go through Data-From Other Sources-Data Connection Wizard. However, this is a different connection type, so I cannot just change my Pivot Tables by "Changing Data Source". I'd rather not have to rebuild all of the report I've created, but this configuration process each time I open Access is driving me crazy and causing other issues. Any help is greatly appreciated.

    Sincerely,

    Grimnebulin

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,171

    Re: Excel 2013 and Access 2013 as Pivot Table External Data Source

    If you have both versoins of Access, then it will configure each time you open the other version.

+ 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. Excel 2010 pivot table with external data source
    By thavarajah in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-24-2015, 11:50 AM
  2. Replies: 0
    Last Post: 02-24-2014, 11:27 AM
  3. Can't sort pivot table in Excel 2013
    By kleemc in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-06-2013, 08:55 AM
  4. Text as value in pivot table . is that possible in excel 2013
    By onenessboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 08:37 AM
  5. Recommended Pivot Table in New Excel 2013
    By AndersExcel in forum Tips and Tutorials
    Replies: 0
    Last Post: 07-21-2012, 07:18 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