Results 1 to 2 of 2

Thread: Problem with importing database to my powerpivot excel file

  1. #1
    Junior Member Reykjavik's Avatar
    Join Date
    Jun 2020
    Posts
    1
    Rep Power
    0

    Problem with importing database to my powerpivot excel file

    Hi,

    I have import many times database to create powerpivot. I have also import many database and connect them. Never been trouble.
    Now, I want to add databaset to my powerpivot excel file. I choose powerpivot > manage > then opens Power Pivot for Excel window, everything is normal. I choose than From other source and choose excel, simply as usual. Then opens Table Import Wizard. Everyhing is ok, and I choose browse.
    In next window I choose the file I want to import.

    Now the problem starts.
    A new window opens and I choose right file. I choose, as usual file with xlsx extenstion.
    I choose the file (a) and expect to press open button and og back to Table import wizard to finish my process (b). But when I have chosen my file (step a), some process starts automatically (c) and excel starts to show Not responding in a few second (d). Nothing happens after that, excel seems to be totally frozen. (e).
    Finally I have to go to task manager and shut excel down.


    I have tried many powerpivot files, with same result.
    I have tried to import many different database in different powerpivot files, with same result.
    I have tried to make a new powerpivot file. No problem with first imported file. But problem with the next one.

    I have never been in this situation before.

    I am using excel 2016, office 365

  2. #2
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    236
    Rep Power
    7
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. Connect Excel to oracle database
    By rohith554 in forum Excel Help
    Replies: 0
    Last Post: 04-09-2018, 04:35 PM
  2. Replies: 1
    Last Post: 06-26-2014, 12:45 PM
  3. Replies: 1
    Last Post: 02-03-2014, 06:17 PM
  4. Replies: 4
    Last Post: 07-29-2013, 08:25 AM
  5. Importing a csv File to a range
    By SDruley in forum Excel Help
    Replies: 21
    Last Post: 11-20-2012, 04:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •