[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

PowerPivot loading data from the internet

Just got PowerPivot last month. I heard lots of good things about it but I was particularly interested in its ability to load data from any websites, e.g. Federal Statistics, Census data, my roulette plays, etc.

Heard it was as easy as copy from the column headers and paste into the PowerPivot window. It doesn't work. Did I miss out anything?
0
nethermit
Asked:
nethermit
1 Solution
 
puppydogbuddyCommented:
Did you place a checkmark in the box that says "Use the first row as column headers" at the bottom of the PowerPivot Paste Preview screen?  As long as the source data is in tabular format,  it should work.  You can see an example (currency exchange data) of how the copy/paste function works in PowerPivot formerly known as Gemini.

    http://blogs.msdn.com/b/powerpivot/archive/2009/10/13/copy-paste.aspx
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now