+ Reply to Thread
Results 1 to 3 of 3

Cannot remove Connection from table - Error

  1. #1
    Forum Contributor
    Join Date
    08-20-2012
    Location
    London,England
    MS-Off Ver
    Excel 2010
    Posts
    184

    Cannot remove Connection from table - Error

    Hi,

    I repurposed a report from a colleague which has a number of pivots associated with it which creates a dashboard; however have suddenly started receiving the below error:

    "We couldn't get data from the Data model. here's the error message we got:

    object reference not set to an instance of an object."

    every time I try to delete the connections, or re-direct them, the error keeps popping up.

    Can anyone advise how to remove the connections or experienced this error before?

    MTIA

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Cannot remove Connection from table - Error

    Hi milo1984,

    Does your file contain ALL the source data that the Pivots use?

    I assume you have gone to 'Data' >> 'Connections' & Remove the links?

    Posting a copy of the file would also help.

    Cheers
    Remember you are unique, like everyone else

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Cannot remove Connection from table - Error

    If you attach your file its more helpful. But anyway try as per below.
    >Go to your Data Cell complete column
    >Click on "DataValidation" Tab > Data Validation
    >If in Formula showing Remove the same


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. Change pivot table data connection if current connection = x
    By BellyGas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2016, 06:05 AM
  2. Replies: 1
    Last Post: 03-29-2016, 04:29 PM
  3. Replies: 2
    Last Post: 05-15-2015, 04:12 PM
  4. Can't figure out how to remove data connection
    By CKlapperich in forum Excel General
    Replies: 1
    Last Post: 08-04-2014, 04:49 PM
  5. Remove data connection, keep PivotCache
    By dgxl in forum Excel General
    Replies: 2
    Last Post: 12-03-2012, 08:51 AM
  6. How to Remove Duplicates After Each Auto Refresh from External Connection?
    By mar0isa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2012, 10:31 PM
  7. SQL Temp table in ado connection = Error Msg
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2010, 06:30 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