How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30129
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Hi Guys, Ive downloaded the 64 bit powerpivot in order to

Customer Question

Hi Guys, I've downloaded the 64 bit powerpivot in order to analyse a 240 M excel file. For some reason I dont manage to access the file as it searches fir an external data source. The data source is however inbedded in the excel. Can you please help?
Submitted: 3 years ago.
Category: Microsoft Office
Expert:  Richard replied 3 years ago.
Thank you for your question, my name is Richard.

This is happening as you are choosing to look into a database.

You need to choose to look at a Flat File (Excel)

To do this

Click Home > Get External Data > From Other Data Sources.

Scroll down and choose Text File.

In Friendly Connection name, type a unique name for this data source connection. This is a required field.

In File Path, specify a full path for the file. This is to your Excel file.

Click Browse to navigate to a location where a file is available.

In Column Separator, choose the separator that separates values into columns.

Click Advanced to specify encoding and locale options for the flat file.

Check the Use first row as column headers box if the first row is a column name.

Preview the data in the selected file, and use the following options to modify the data import.

NOTE Only the first 50 rows in the file are displayed in this preview.

Clear the checkbox on columns you want to exclude from the import.

Click the down-arrow button in the column filter to sort and filter the data. For example, if the column contains product category names, you can select individual categories to import.

Click OK to return to the Table Import wizard.

Click Finish to import.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you