• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Tachytelic.net

  • Sco Openserver
    • Sco Unix Support
    • SCO Openserver Installation ISOs
    • SCO Openserver Binaries
    • Add a Hard Drive to an Openserver 5 Virtual Machine
    • Install SCO Vision SQL-Retriever ODBC Driver on Windows 10
    • License Expired on Virtual SCO Openserver Installation
    • How to reset the root password on SCO Openserver 5
  • Scripting
    • PowerShell
      • Add leading zeros
      • Check if a File Exists
      • Grep with Powershell
      • Create Environment Variables
      • Test for open Ports
      • Append to a Text File
    • VBScript
      • Check if a File Exists
      • lpad and rpad functions
      • Windows Update E-Mail Notification
  • Office 365
    • Connect to Office 365 with PowerShell
    • Add or remove an email alias using Powershell
    • Change Primary email address of Active Directory user
    • How to hide an AD user from the Global Address List
    • How to hide mail contacts from the Global Address List
    • Change the primary email address for an account with PowerShell
    • Change Primary email address of an AD User
    • Grant a single user access to access to all calendars
    • Forward email to an external address using Powershell
    • Convert shared mailbox to user mailbox with Powershell
  • Get in Touch
  • About Me
    • Privacy Policy

Power Pivot for Excel: Object Reference not set to an instance of an object

April 8, 2019 by Paulie 3 Comments

When trying to delete a table from the Data Model in Excel 2016 you may get the error “Object reference not set to an instance of an object.”

Image showing Excel error "Object reference not set to an instance of an object." when trying to delete a table from the data model.
Object reference not set to an instance of an object.

Having tried all sorts of complicated things to rectify the error, nothing seemed to get rid of it. The solution is actually very simple:

  1. Go into Data View
  2. Right click on the table on the tab strip at the bottom of the data view:
    Image showing context menu when right clicking on a table in data view of Power BI for Excel
  3. Click on Delete.
  4. Choose Yes when prompted if you really want to delete the table.

Your table should now be deleted, frustrating that an operation as simple as this produces an error, but at least there is a workaround.

Related

Filed Under: Office 365

Reader Interactions

Comments

  1. Josh says

    October 1, 2019 at 1:56 am

    Awesome – this was really annoying me!

  2. GC says

    July 22, 2020 at 3:53 pm

    Thanks for this as it is exactly what I needed right now.

  3. JG says

    August 25, 2020 at 5:27 pm

    Thanks Paul! I foolishly deleted an Excel linked worksheet before removing it from the data model, but you saved the day!

Leave a Reply Cancel reply

Primary Sidebar

Link to my LinkedIn Profile
Go to mobile version