One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an ATOM feed) and its data can be imported directly into a PowerPivot for Excel workbook. To get this thing to work, one of the key things that I remind people regularly is to make sure [...]
Posts Tagged ‘Troubleshooting’
Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
Posted in PowerPivot, tagged SharePoint, Troubleshooting on August 21, 2010 | Leave a Comment »
Delegation, Claims, Active Directory…Oh My!…Aw Crap!
Posted in PowerPivot, SharePoint, tagged Active Directory, Configuration, Delegation, Excel Services, FAQ, Troubleshooting, Upgrade on April 8, 2010 | 2 Comments »
Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written [...]
Ramblings about missing time … and #PowerPivot sneak peek!
Posted in PowerPivot, tagged Book, Configuration, Connectivity, Design, Excel Services, FAQ, Internals, SharePoint, Troubleshooting on April 5, 2010 | 4 Comments »
Wow, I just checked and its been more than a month since I did my last blog post! So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But [...]
Reading your #PowerPivot Profiler trace
Posted in PowerPivot, tagged Troubleshooting on January 30, 2010 | 2 Comments »
To help troubleshoot your PowerPivot for Excel workbook, you can click on Settings within the PowerPivot selection in the Office Ribbon which will bring up the Support & Diagnostics tab within the PowerPivot Options & Diagnostics dialog. Click on the checkbox next to “Client tracing is enabled” and after opening the PowerPivot window, you will [...]
The Great PowerPivot FAQ!
Posted in PowerPivot, tagged Troubleshooting on January 6, 2010 | Leave a Comment »
Just in case you’re not already aware of this, some of great contributors to the PowerPivot community are now adding and moderating to the Great PowerPivot FAQ. Please check it out and email us your questions as well! Enjoy!
Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI
Posted in PowerPivot, tagged Excel, SharePoint, Troubleshooting on January 6, 2010 | 2 Comments »
When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file. This is different than uploading the file by using the SharePoint UI as the SharePoint UI uses a different mechanism via http to upload the [...]

