+ Reply to Thread
Results 1 to 1 of 1

Can't Open Pivot Table Source File '[Dashboard-MCT.xlsm]Resources2-Calc'

  1. #1
    Registered User
    Join Date
    07-10-2016
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    1

    Can't Open Pivot Table Source File '[Dashboard-MCT.xlsm]Resources2-Calc'

    Hello everyone,

    I am having an issue with Pivot Tables in Excel and would really appreciate any help.

    I have an Excel file named 'Dashboard-MCT' with Pivot Tables and the Source data in the Excel file. Everything works fine.

    When I change the name of the Excel file or copy the file, I get an error because all Pivot Tables source file don't automatically update.

    For example for a Pivot Table in the "Resources2-Calc" tab, I get the following error : Can't Open Pivot Table Source File '[Dashboard-MCT.xlsm]Resources2-Calc'. (Dashboard-MCT is my old Excel file name).

    How can I do to correct this ?

    I am working with Excel 2016. Some of my colleagues that uses Excel 2010 also seem to have this issue.

    Thanks

    Nicolas
    Last edited by nicolassido34; 07-10-2016 at 09:08 AM.

+ 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. Cannot open pivot table source file
    By norriemackay in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-28-2014, 01:33 PM
  2. Replies: 0
    Last Post: 09-12-2014, 03:20 AM
  3. Cannot open Pivot Table source '[TR CallDetail.xlsm]'Invalid Calls
    By zabolyx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2013, 05:45 PM
  4. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  5. Replies: 0
    Last Post: 09-02-2011, 04:39 PM
  6. [SOLVED] Create Pivot Table: Cannot Open Pivot Table Source File
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-05-2010, 05:11 AM
  7. [SOLVED] cannot open pivot table source file - error
    By Martha in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-08-2006, 06:20 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