{"id":66,"date":"2008-06-05T20:50:28","date_gmt":"2008-06-06T01:50:28","guid":{"rendered":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/?p=66"},"modified":"2008-06-05T21:30:30","modified_gmt":"2008-06-06T02:30:30","slug":"excel-2007-pivot-table-with-sharepoint-on-vista-pc-works-good-after-sp1","status":"publish","type":"post","link":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/66_excel-2007-pivot-table-with-sharepoint-on-vista-pc-works-good-after-sp1","title":{"rendered":"Excel 2007 Pivot Table with SharePoint On Vista PC &#8211; works good after SP1"},"content":{"rendered":"<p>Our company is using Microsoft Excel 2007 with Microsoft Office SharePoint Server 2007 and Excel Services as the primary interface to access Analysis Services cube data. This works very well on Windows XP PC, but was almost unusable on Windows Vista PC. On Vista PC you would get just too many &#8220;Enter UserName\/Password&#8221; dialogs.<\/p>\n<p>Here is what would happen on Vista PC when you\u00a0try to open Excel\u00a0report with Pivot Table from the SharePoint:<!--more--><\/p>\n<ul>\n<li>You\u00a0would browse SharePoint document library and would find\u00a0report with Pivot table(s) that\u00a0you want to open in Excel.<\/li>\n<li>You\u00a0would hit Open in Excel button and there would be message: &#8220;Do you want to open or save this file?&#8221;. So far no problems &#8211; hit Open.<\/li>\n<li>Then Excel would start, Pivot table would be loaded, then for a half of the seconds you would see &#8220;Enter UserName and Password&#8221; dialog. Then Excel would get a focus and would hide UserName\/Password dialog and then another &#8220;Connecting&#8221; Dialog would pop up. After that you had to find that UserName\/Password dialog and hit &#8220;Cancel&#8221;. There was no point entering UserName\/Password and clicking on the &#8220;Save&#8221; check-box &#8211; that information was ignored. After hitting Cancel, if you have more than one pivot table in this Excel file, you would get another UserName\/Password dialog for each Pivot Table. Just after that you could finally explore your pivot table.<\/li>\n<\/ul>\n<p>Because of these annoying prompts we avoided using Vista OS.<\/p>\n<p>But this week I saw interesting video about <a id=\"ctl00_MainPlaceHolder_Starter_TitleLink\" title=\"Permalink\" href=\"http:\/\/edge.technet.com\/Media\/Windows-Vista-SP1-UAC-improvements\/\" target=\"_blank\">Windows Vista SP1 UAC improvements<\/a>. So I decided to test if anything changes after installing SP1 on Vista PC.<\/p>\n<p>It took me about 50 minutes to upgrade my Vista PC with\u00a0SP1, and after that I noticed the difference right away &#8211; all these annoying\u00a0prompts were gone. Now as soon as you hit Open button, Excel opens report and you can explore your Pivot Table data. Very nice, finally we can migrate to Windows Vista OS and recommend this to our clients. So if you are using SharePoint and Excel with Analysis Services, make sure you upgrade to Vista SP1.<\/p>\n<p>There is also another warning that you can get after opening Excel 2007\u00a0with Pivot table:<\/p>\n<blockquote><p>Security warning: &#8220;Data Connection have been disabled&#8221;<br \/>\n(x) Help protect me from unknown content (recommended)<br \/>\n( ) Enable this content<\/p><\/blockquote>\n<p>You can get this warning on Windows Vista or Windows XP. To get rid of it you have to either add Excel file location to the &#8220;Trusted locations&#8221; or enable all data connections for external content in the Excel\u00a0Trust Center.\u00a0Step by step\u00a0guide for this you can find in <a href=\"http:\/\/www.ssas-info.com\/analysis-services-faq\/36-excel\/98-how-to-disable-excel-pivot-table-security-warning-data-connections-have-been-disabled-enable-this-content\" target=\"_blank\">this post<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Our company is using Microsoft Excel 2007 with Microsoft Office SharePoint Server 2007 and Excel Services as the primary interface to access Analysis Services cube data. This works very well on Windows XP PC, but was almost unusable on Windows Vista PC. On Vista PC you would get just too many &#8220;Enter UserName\/Password&#8221; dialogs. Here [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/66"}],"collection":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/comments?post=66"}],"version-history":[{"count":0,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/66\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/media?parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/categories?post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/tags?post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}