+ Reply to Thread
Results 1 to 3 of 3

Excel cannot connect to file, pivot table, ...

  1. #1
    Registered User
    Join Date
    08-01-2017
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    57

    Excel cannot connect to file, pivot table, ...

    Hi,

    I am updating a workbook and get the errors below. Is there a way I can find and remove the table or link that is causing this error? Unfortunately I do not where the link is excel is referencing.

    Error 1
    We can't connect to...

    Error 2
    Microsoft Excel cannot access the file...

    Error 3
    Cannot open Pivot table source file...
    Last edited by bbeards; 01-29-2018 at 12:38 PM.

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

    Re: Excel cannot connect to file, pivot table, ...

    menu: Data, connections

  3. #3
    Registered User
    Join Date
    08-01-2017
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    57

    Re: Excel cannot connect to file, pivot table, ...

    Quote Originally Posted by ranman256 View Post
    menu: Data, connections
    The connections list is blank.

+ 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. Connect several excel files into one file
    By html in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-02-2016, 07:15 PM
  2. Why does ADO force Excel to open a file it's attempting to connect to?
    By dmasters4919 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 10:21 AM
  3. Connect to table from another excel workbook using ADO
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2014, 06:19 AM
  4. help on vba code to connect for pivot table performance with splited workbook
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2013, 07:36 AM
  5. Replies: 0
    Last Post: 05-28-2011, 11:31 AM
  6. Excel file tries to connect to internet links
    By Doctorul in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 05-14-2009, 02:46 AM
  7. how to connect visual basic with excel file ?
    By taha in forum Excel General
    Replies: 2
    Last Post: 10-26-2005, 11:05 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