+ Reply to Thread
Results 1 to 2 of 2

Can't Refresh Pivot Table When Using External Data Source

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Can't Refresh Pivot Table When Using External Data Source

    Hi! I am using an Excel file (Raw.xlsx) to store my raw data, and take another Excel file (Pivot.xlsx) to make PivotTable from Raw.xlsx
    When generating the PivotTable, every works fine. When click [Refresh] in the Raw.xlsx, whatever changes been made in the Raw.xlsx can "sync" to the Pivot.xlsx

    However, once I save and reopen the Pivot.xlsx, I can't refresh the PivotTable anymore. I've tried changing Data Source, but it doesn't work. Can anyone help me on this? Thank you very much!!

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Can't Refresh Pivot Table When Using External Data Source

    Hi,

    Please try the following and see if it works:

    1. Right click on the Pivot Table
    2. Pivot T'able Options
    3. Select "Data Tab"
    4. Select the tick mark "Refresh data when opening the file"



    Regards,
    Chandra


    Please click on '* Add Reputation' if this was helpful in resolving the issue.

+ 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. Automatic refresh of pivot table on changes in external data source.
    By namrata773 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2013, 04:43 AM
  2. Replies: 0
    Last Post: 08-14-2013, 06:31 AM
  3. Macro to refresh pivot table and update data source
    By TBO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 01:09 PM
  4. [SOLVED] Auto Refresh Pivot Table Once External Data source Changes
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2012, 10:33 AM
  5. Replies: 0
    Last Post: 07-08-2006, 07:45 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