The following information was added to the PowerPivot-Info.com website during the month of October.

PowerPivot News

- Oct 28, 2010 - Microsoft release updated build of PowerPivot for Excel
- October 08, 2010 - New book released "Microsoft PowerPivot for Excel 2010: Give Your Data Meaning"

PowerPivot Posts

- Can I access PowerPivot via a data access API?
- Q: I have integer amount that represents duration in seconds. How can show this amount in format "h:mm:ss"?
- Basket Analysis, PowerPivot and NodeXL
- General problems with Gallery snapshots not being taken - no items listed in the ULS log
- Building Creative PowerPivot Solutions
- Importing XML data
- Data feeds: Cannot get schema? But it is there ...
- Snapshots not being taken
- PowerPivot Glossary
- Simple Basket Analysis in DAX
- PowerPivot Mind Meld: To Consult is to Train
- PowerPivot and Many to Many Relationships
- Refreshing PowerPivot Gallery thumbnails
- Banding with PowerPivot
- On Performance and Stress testing PowerPivot for SharePoint
- Round 2: Calculating Previous Year Marketing Calendar Values with DAX
- Why use the PowerPivot Time intel golden rules? With examples
- Interview with Marco Russo and Alberto Ferrari about their new book about PowerPivot
- Quantum shifts with PowerPivot
- Shortcuts to start Excel with or without PowerPivot add-in
- Manage your PowerPivot datafeeds in a SharePoint datafeed library
- Video - PowerPivot Calculated Columns
- Video - Install Microsoft PowerPivot for SharePoint on a Domain Controller
- More on the CALCULATE function…
- Bug: cannot install PowerPivot if a SQL Server shared folder has been specified in a previous installation to other than the default folder
- A Peek Inside: Special steps for Excel Services-only app servers
- Top 5 Ways PowerPivot Helps Excel Pros
- DAX functions – CALCULATE and CALCULATETABLE
- How do I – Uninstall PowerPivot for SharePoint 2010

PowerPivot Tips

- SharePoint has a new high severity health rule for SharePoint 2010 that raises an error if your machines does not have 2X the amount of physical memory in free disk space
- When specifying your query for importing data into PowerPivot, make sure you columns are unique and only returned once in the query! Otherwise error "Cannot load preview for table "summary1"

Comments

- any bug fixes? like https://connect.micr
- Will, it appears that this release conta
- What's new?
- Thank you for sharing this. First I
- Thanks for that, I used your example and

And thank you for rating the articles!