can't add data to Data Model - Excel

Question

I have Excel 2016 32 bits installed. it's frustrating that I can't add data to data model even if it's a very small table. Always receive an error message about shortage of memory.  I have already closed all the applications and it's such a small table.  I have even asked IT to install Office 64bits on my computer, but it turns out to be disaster. Not sure what else I can do.

Thanks!

Answer 1

Hi Wang,

I am John, an Independent Advisor and a Microsoft user like you. I'm here to work with you on this issue.

I am sorry to hear this is happening to you. I have found similar thread regarding your issue, please try the suggested workaround from Rohn007, an MVP/Article Author, here:

https://answers.microsoft.com/en-us/msoffice/fo...

I hope it worked out well for you. If not, please reply back to this forum to let me know. I will be glad to follow up and help you.

Regards,

John

Answer 2

As stated on the thread, Turn Off Hardware Acceleration in Office 2010 / 2013 Application

1. File menu,
2. Options command
3. Advanced option
4. Scroll down to the Display section of the dialog,
5. toggle the check the box for “Disable hardware graphics acceleration

Please let me know what will happen.

Regards,

John

Answer 3

As stated on the thread, Turn Off Hardware Acceleration in Office 2010 / 2013 Application

1. File menu,
2. Options command
3. Advanced option
4. Scroll down to the Display section of the dialog,
5. toggle the check the box for “Disable hardware graphics acceleration

Please let me know what will happen.

Regards,

John

Thanks! I followed the instruction, this time I managed to load a small table to data model, but when it comes to a table with 10000 records, I received a similar message.

Answer 4

Hi Wang,

Make sure you have all latest video/graphics drivers installed. Also update Office by going to FILE>Account>Office Update>Update Now.

Please let me know what will happen.

Regards,

John