+ Reply to Thread
Results 1 to 12 of 12

Powerpivot import error

  1. #1
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 2016, Windows 10
    Posts
    104

    Powerpivot import error

    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

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Powerpivot import error

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

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 2016, Windows 10
    Posts
    104

    Re: Powerpivot import error

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

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Powerpivot import error

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

  5. #5
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 2016, Windows 10
    Posts
    104

    Re: Powerpivot import error

    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.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Powerpivot import error

    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?

  7. #7
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 2016, Windows 10
    Posts
    104

    Re: Powerpivot import error

    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.
    Attached Images Attached Images

  8. #8
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Powerpivot import error

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

  9. #9
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 2016, Windows 10
    Posts
    104

    Re: Powerpivot import error

    thank you for your patience.
    Attached Images Attached Images

  10. #10
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Powerpivot import error

    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

  11. #11
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 2016, Windows 10
    Posts
    104

    Re: Powerpivot import error

    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.
    Last edited by Reykjavik; 03-19-2013 at 02:22 PM.

  12. #12
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Powerpivot import error

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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