Powerpivot import error

**Reykjavik** · 03-18-2013, 10:54 AM

Hi,

I am trying to import data with powerpivot.

But suddenly, I always recieve an error
"The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.''

What can I do and what should I do?

I am using 32bit of excel. I have heard if I use 64bit I will receive other problems.
What is the pros and cons of using 64 instead of 32?
Can I fix my current error?

I am using windows 7.
I have 8gb memory

**JosephP** · 03-18-2013, 05:32 PM

how much data are you importing and which version of office? (clearly not 2003 as your profile shows!)

**Reykjavik** · 03-19-2013, 05:56 AM

I will change my profile, I am using excel 2010.
I am importing big data file, 2x 55mb

**JosephP** · 03-19-2013, 08:03 AM

55MB is not very big-what other applications are you running and how much free memory do you have?

**Reykjavik** · 03-19-2013, 09:49 AM

RAM 8,0GB (7,88 usable)

Operating system W7 64bit, service pack 1
processor: Core i3-2120 3,3GHz
But I believe I am running 32bit version of office (I am not sure)
Free disk space 390gb of 450gb.

It doesn't matter whether I run other programs like Lotus Notes or quit all other programs.
I don't use msn, I sometimes use skype.

**JosephP** · 03-19-2013, 11:05 AM

I was asking how much free memory you have not how much in total

have you applied any office or windows updates shortly before the problem started?

**Reykjavik** · 03-19-2013, 12:59 PM

I'm sorry I didn't understand. Hope the attachments will help.

This is my task manager when I try to import datafile2. I have closed all other programs.

**JosephP** · 03-19-2013, 01:16 PM

how much memory is your excel process using? your second picture appears completely black to me?

**Reykjavik** · 03-19-2013, 01:36 PM

thank you for your patience.

**JosephP** · 03-19-2013, 01:47 PM

that memory usage looks high for the amount of data you described-do you have a lot of distinct values in the columns? (good article on powerpivot memory usage here http://sqlblog.com/blogs/marco_russo...for-excel.aspx)

64bit office is mainly an issue if you use add-ins in any of the office applications or use non-msforms activex controls such as the windows common controls -see
http://office.microsoft.com/en-gb/wo...010369476.aspx
and
http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

**Reykjavik** · 03-19-2013, 02:18 PM

Thankyou Joseph and again thankyou for your patience.

I have two data files one from 2011 other from 2012, with same item number, names etc. But different sales amount, different outstanding claims.

Sometimes the obvious thing is not so obvious. I skip some columns and bingo, 3 million rows were successfully transferred.

Again, thankyou.

**JosephP** · 03-19-2013, 02:22 PM

you're welcome-glad I was of some help :-)

Powerpivot import error

LinkBack

Thread Tools

Rate This Thread

Display

Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Re: Powerpivot import error

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions