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.”
Having tried all sorts of complicated things to rectify the error, nothing seemed to get rid of it. The solution is actually very simple:
- Go into Data View
- Right click on the table on the tab strip at the bottom of the data view:
- Click on Delete.
- 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.
Josh says
Awesome – this was really annoying me!
GC says
Thanks for this as it is exactly what I needed right now.
JG says
Thanks Paul! I foolishly deleted an Excel linked worksheet before removing it from the data model, but you saved the day!