{"id":4519,"date":"2012-10-31T17:01:50","date_gmt":"2012-10-31T17:01:50","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=4519"},"modified":"2012-10-31T17:29:53","modified_gmt":"2012-10-31T17:29:53","slug":"export-to-spreadsheet-from-sharepoint-2007-with-excel-2010","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm","title":{"rendered":"Export to spreadsheet from SharePoint 2007 with Excel 2010"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignright\" title=\"SharePoint 2007 Export to Spreadsheet\" src=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/sharepoint-2007-export-to-spreadsheet.png?resize=154%2C156&#038;ssl=1\" alt=\"\" width=\"154\" height=\"156\" \/>I frequently have to export data from a SharePoint list to Excel but earlier today I found it no longer works since I&#8217;ve upgraded to Office 2010. \u00a0Our SharePoint infrastructure is based on SharePoint 2007 and each time I attempted to Export to Spreadsheet from the Actions menu on the Toolbar, Excel would hang.<\/p>\n<p>Luckily, I found <a href=\"http:\/\/tedgustaf.com\/en\/blog\/2011\/10\/trying-to-synchronize-data-between-excel-2010-and-a-sharepoint-2007-list\/\">Gustaf Lindqvist&#8217;s post on synchronising data between Excel 2010 and a SharePoint 2007 list<\/a>. He suggests installing the <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=23734\">2007 Office System Driver Data Connectivity Components<\/a>\u00a0(I wasn&#8217;t getting an error message to help me find the\u00a0problem\u00a0&#8211; just a &#8220;Not Responding&#8221; application and the &#8220;doughnut of death&#8221;.<\/p>\n<p>It&#8217;s still a bit flaky &#8211; and I&#8217;m not sure I have the complete answer (in fact, I suspect there may even be issues with some of the views in SharePoint) &#8211; but at least I can export data now&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I frequently have to export data from a SharePoint list to Excel but earlier today I found it no longer works since I&#8217;ve upgraded to Office 2010. \u00a0Our SharePoint infrastructure is based on SharePoint 2007 and each time I attempted to Export to Spreadsheet from the Actions menu on the Toolbar, Excel would hang. Luckily, &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Export to spreadsheet from SharePoint 2007 with Excel 2010<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[218],"tags":[188,93],"class_list":["post-4519","post","type-post","status-publish","format-standard","hentry","category-technology","tag-excel","tag-sharepoint"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Export to spreadsheet from SharePoint 2007 with Excel 2010 - markwilson.it<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export to spreadsheet from SharePoint 2007 with Excel 2010 - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"I frequently have to export data from a SharePoint list to Excel but earlier today I found it no longer works since I&#8217;ve upgraded to Office 2010. \u00a0Our SharePoint infrastructure is based on SharePoint 2007 and each time I attempted to Export to Spreadsheet from the Actions menu on the Toolbar, Excel would hang. Luckily, &hellip; Continue reading Export to spreadsheet from SharePoint 2007 with Excel 2010\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-31T17:01:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-10-31T17:29:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-2007-export-to-spreadsheet.png\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Export to spreadsheet from SharePoint 2007 with Excel 2010\",\"datePublished\":\"2012-10-31T17:01:50+00:00\",\"dateModified\":\"2012-10-31T17:29:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\"},\"wordCount\":152,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-2007-export-to-spreadsheet.png\",\"keywords\":[\"Microsoft Excel\",\"Microsoft SharePoint\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\",\"name\":\"Export to spreadsheet from SharePoint 2007 with Excel 2010 - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-2007-export-to-spreadsheet.png\",\"datePublished\":\"2012-10-31T17:01:50+00:00\",\"dateModified\":\"2012-10-31T17:29:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-2007-export-to-spreadsheet.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-2007-export-to-spreadsheet.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/10\\\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export to spreadsheet from SharePoint 2007 with Excel 2010\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output &gt; \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Export to spreadsheet from SharePoint 2007 with Excel 2010 - markwilson.it","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm","og_locale":"en_GB","og_type":"article","og_title":"Export to spreadsheet from SharePoint 2007 with Excel 2010 - markwilson.it","og_description":"I frequently have to export data from a SharePoint list to Excel but earlier today I found it no longer works since I&#8217;ve upgraded to Office 2010. \u00a0Our SharePoint infrastructure is based on SharePoint 2007 and each time I attempted to Export to Spreadsheet from the Actions menu on the Toolbar, Excel would hang. Luckily, &hellip; Continue reading Export to spreadsheet from SharePoint 2007 with Excel 2010","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm","og_site_name":"markwilson.it","article_published_time":"2012-10-31T17:01:50+00:00","article_modified_time":"2012-10-31T17:29:53+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-2007-export-to-spreadsheet.png","type":"","width":"","height":""}],"author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Export to spreadsheet from SharePoint 2007 with Excel 2010","datePublished":"2012-10-31T17:01:50+00:00","dateModified":"2012-10-31T17:29:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm"},"wordCount":152,"commentCount":1,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-2007-export-to-spreadsheet.png","keywords":["Microsoft Excel","Microsoft SharePoint"],"articleSection":["Technology"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm","name":"Export to spreadsheet from SharePoint 2007 with Excel 2010 - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-2007-export-to-spreadsheet.png","datePublished":"2012-10-31T17:01:50+00:00","dateModified":"2012-10-31T17:29:53+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-2007-export-to-spreadsheet.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-2007-export-to-spreadsheet.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/10\/export-to-spreadsheet-from-sharepoint-2007-with-excel-2010.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Export to spreadsheet from SharePoint 2007 with Excel 2010"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output &gt; \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1589,"url":"https:\/\/www.markwilson.co.uk\/blog\/2010\/01\/a-look-forward-to-sharepoint-2010.htm","url_meta":{"origin":4519,"position":0},"title":"A look forward to SharePoint 2010","author":"Mark Wilson","date":"Tuesday 26 January 2010","format":false,"excerpt":"Over the years, I've dipped in and out of SharePoint several times and, last week, I took myself\u00c2\u00a0along to the Edge user group's meeting at Microsoft's London offices to listen to SharePoint MVP, Dave McMahon, talk about what's coming in SharePoint 2010. Before looking at the various product editions, it's\u2026","rel":"","context":"In \"Microsoft SharePoint\"","block_context":{"text":"Microsoft SharePoint","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/sharepoint"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1483,"url":"https:\/\/www.markwilson.co.uk\/blog\/2009\/07\/what-and-where-is-sharepoint-server-2009.htm","url_meta":{"origin":4519,"position":1},"title":"What (and where) is SharePoint Server 2009?","author":"Mark Wilson","date":"Friday 24 July 2009","format":false,"excerpt":"I came across an interesting dialog box last week whilst trying to connect to a Microsoft Office SharePoint Server 2007 site with the SharePoint Designer 2010 technical preview. The dialog told me that Microsoft Office SharePoint Designer 2007 is needed to work with older versions of SharePoint Server but interestingly\u2026","rel":"","context":"In \"Microsoft Office\"","block_context":{"text":"Microsoft Office","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/office"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5805,"url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-excel-tips-display-worksheet-name-validate-data-editing-microsoft-project-files-stored-sharepoint-xps-pdf-conversion-service.htm","url_meta":{"origin":4519,"position":2},"title":"Short takes: Excel tips to display the worksheet name and validate data; editing Microsoft Project files stored on SharePoint; and an XPS to PDF conversion service","author":"Mark Wilson","date":"Monday 17 August 2015","format":false,"excerpt":"Another collection of mini-posts based on recent IT trials and tribulations... Excel tips to display the worksheet name in a cell\u00a0and to validate data Last week, I was working on an Excel spreadsheet that acts as a plan for a series of tests. Each sheet has the same format, with\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1440,"url":"https:\/\/www.markwilson.co.uk\/blog\/2009\/05\/faster-entry-of-persongroup-names-in-sharepoint.htm","url_meta":{"origin":4519,"position":3},"title":"Fast(er) entry of person\/group names in SharePoint","author":"Mark Wilson","date":"Wednesday 20 May 2009","format":false,"excerpt":"Together with my colleague, Alan Dodd, I've spent a considerable amount of time this week cleansing data in a SharePoint list. Quite why I can't import e-mail addresses from an Excel spreadsheet to a column of type \"Person or Group\" I don't know, but we couldn't seem to make it\u2026","rel":"","context":"In \"Microsoft SharePoint\"","block_context":{"text":"Microsoft SharePoint","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/sharepoint"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1780,"url":"https:\/\/www.markwilson.co.uk\/blog\/2010\/04\/introducing-microsoft-powerpivot.htm","url_meta":{"origin":4519,"position":4},"title":"Introducing Microsoft PowerPivot","author":"Mark Wilson","date":"Wednesday 21 April 2010","format":false,"excerpt":"I spent last week hanging out in West London at the Microsoft UK TechDays events in order to learn something more about the technologies I work with and something new about a few others.\u00c2\u00a0 Thursday's SQL Server\/Business Intelligence sessions definitely fell into the latter category and I saw some pretty\u2026","rel":"","context":"In \"Microsoft Excel\"","block_context":{"text":"Microsoft Excel","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/excel"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":768,"url":"https:\/\/www.markwilson.co.uk\/blog\/2007\/04\/microsoft-sharepoint-products-and-technologies.htm","url_meta":{"origin":4519,"position":5},"title":"Microsoft SharePoint products and technologies","author":"Mark Wilson","date":"Wednesday 11 April 2007","format":false,"excerpt":"Over the last few years, I've had a couple of attempts at learning about the various Microsoft SharePoint products and technologies but I've never really had the chance to implement SharePoint for a customer. Recently though, I've had the opportunity to get involved with some work around Microsoft Office SharePoint\u2026","rel":"","context":"In \"Microsoft SharePoint\"","block_context":{"text":"Microsoft SharePoint","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/sharepoint"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=4519"}],"version-history":[{"count":4,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4519\/revisions"}],"predecessor-version":[{"id":4525,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4519\/revisions\/4525"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=4519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=4519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=4519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}