David Overton's Blog and Discussion Site
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

Browse by Tags

  • Office Live Workspace: New Web Functionality for Microsoft Office

    I thought I should offer some clearer info on what is coming in Office Live Workspace Available at no charge, Office Live Workspace facilitates the following : Access documents anywhere. Organise documents and projects for work, school and home online, and work on them from almost any computer - even one not connected to the company or school network. Save more than 1,000 Microsoft Office documents to one place online and access them via the Web. Share with others. Work collaboratively on a project with others in a password-protected, invitation-only online workspace, helping to eliminate version-control challenges when e-mailing drafts to multiple people. Collaborators who don't have a desktop version of Microsoft Office software can still view and comment on the document in a browser. Extend Microsoft Office. Easily connect to Microsoft Office Word, PowerPoint ® , Excel ® and Outlook ® on their PC via the Web. Pre-register for the beta of Office Live Workspace today at www.officelive.co.uk Some people are...
  • An amazing deal for UK Students to get Office 2007 ULTIMATE for £39 to own or £13 per year to "rent it" - tell them all about it!

    This offer is called "The Ultimate Steal" and I have to say I can see why. Microsoft is now offering Office 2007 to university students for the sort of price that would normally suggest this was a con or stolen software, although as Steve Clayton has already verified, it is real . The Offer is simple "Get Microsoft® Office Ultimate 2007 for just £38.95 to own or £12.95 to use for one year" As I said this is only open for people in education, but if you go to The Ultimate Steal presented by Microsoft you can get lots more info. A summary, but not complete, eligibility requirements are: You must hold a valid email address at a U.K. educational institution ending in .ac.uk (for example, leina@contoso.university.ac.uk) Be actively enrolled with at least 0.5 course load. You must be able to provide proof of enrollment status (ie, student card) upon request by Microsoft. If you are unable to provide proof of enrollment, you will be required to pay the full retail price of Office Ultimate 2007 (approximate...
  • SBSC and small business partners get a chance to find out more about the market they sell into and Microsoft technology that is here and coming

    Want to talk to Microsoft and hear where we see the market, opportunities and key technologies? Then get to one of these (there are even more dates on the web site) :-) We are taking to the road to see you, our partners! Jump in the driver's seat and join us to find out how we plan to get your business motoring. A top Microsoft technology and business team will map out the latest developments in the server and desktop markets and take you on the journey from market opportunity to technical 'how to' demonstrations. We'll get under the hood of Windows Vista and the 2007 Microsoft Office system, along with the Office Ready PC, giving you detailed insights to get your business moving. And of course, we'll be outlining the route ahead for the new Windows Server 2008, with its built-in web and virtualisation technologies for increasing the reliability and flexibility of your customers' server infrastructure. Additionally we will be running exclusive SBSC pre-sessions at four of the locations...
  • re-iterate - Action Pack Office 2007 licenses will not work with Terminal Server and at the moment this will not change

    I'm sorry to be so blunt. I get asked about this quite often, so thought I would write it down. The problem is that the Office 2007 applications will only run in a Terminal Server environment if volume licensing media and a volume license keys are used. Unfortunately the MAPS kit does not include volume licensing media, which means that the Office 2007 can not be used in a TS environment. There are some options on how to move this forward, which are: Acquire the Premium edition of MSDN via the Microsoft Open License Program. http://msdn2.microsoft.com/en-us/subscriptions/aa700832.aspx or For their own business use, Partners could purchase Office 2007 via the Microsoft Open License Program or one of the other volume licensing programs. Some people have commented that the same restrictions were not in place for the beta of Office 2007. It is worth noting that the beta code for Office 2007 software was created without regard to the channels that it will later be sold or distributed in. For this reason, Office...
  • What to do when you get the error "This modification is not allowed because the selection is locked" in Word 2007

    I was contacted by Gerald who had this problem and after a bit of research I found the answer. The text explaining how to do this can be found at http://www.word07.com/locking.htm , however to explain a bit more, here are a few pictures and words. The problem arises when you "group" some text in the developer tab, so the answer is to ungroup it. 1st off, ensure the developer tab is showing by going to the file (round pearl menu button in the top left corner) and selecting the button on the bottom of the menu called "Word Options". This will bring you up a screen as below Now ensure the developer toolbar is enabled with a tick as in the picture Go to the document and find the text that you can't modify Ensure the developer toolbar is displayed and click in the document where the text is and then press the Group button in the toolbar and press the Ungroup option as below That is it - you should now be able to modify the text without any problems. If this does not solve your problem, please...
  • Finding out where something is in Office 2007 and where it was in Office 2003 (Outlook, Word, Excel, PowerPoint and Access)

    I saw this recently and thought I had to blog it - if you know something was there in Office 2003 and now can't find it in Office 2007 then look at these spreadsheets to get some advice. The 1st set of links (ms-help:) will work on a machine with Office 2007 installed and the 2nd set pull the data from the Microsoft Office web site. From the installed help files Outlook ms-help://MS.RIBBON.12.1033/RIBBON/outlookmap.xls Word ms-help://MS.RIBBON.12.1033/RIBBON/wordmap.xls Excel ms-help://MS.RIBBON.12.1033/RIBBON/excelmap.xls PowerPoint ms-help://MS.RIBBON.12.1033/RIBBON/powerpointmap.xls Access ms-help://MS.RIBBON.12.1033/RIBBON/accessmap.xls From the Internet Outlook http://office.microsoft.com/search/redir.aspx?AssetID=AM101954661033&CTT=5&Origin=HA101934281033 Word http://office.microsoft.com/search/redir.aspx?AssetID=AM101938681033&CTT=5&Origin=HA100625841033 Excel http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033 PowerPoint http://office...
  • The Open XML Vote (OOXML) and why I hate politics

    This is a rant and it is my opinion and does not reflect that of Microsoft or others - It is my Opinion! From 1992 to 1995 I had to write document converters - I had to pick apart binary file formats and translate them to another format. It was hard work and I JUST WISHED people would create a largely encompassing standard for documents that was documented so I did not have to do all the work myself. Role forward to today, Office is still the prominent document format (which is now documented on http://msdn.microsoft.com ), but there is a new kid in town that encompass everything that an Office document is and more. This is the Open XML document format. People have cried for years that they wanted the Office Document standard to become more than a defacto standard, they wanted it to become a format an open standard. It was always going to be large, but to cover all the features and functions available in Office, it would have to be. There is no point in the standard being something different to that used in Office...
  • SharePoint User Group Meetings in UK (Newcastle and Reading) in September

    I got this e-mail today from the UK SharePoint User Group. They have two meetings coming up, one in Reading and one in Newcastle. Since SBS includes WSS and you can easily load WSS v3 onto it too, here are the details: Newcastle - 10th September MOSS MVP and general all round nice guy Spencer Harbar will be presenting an evening of goodness for all that attend. Arrive 6:30 for a 7pm start 1st Presentation: MOSS Server Farm Architecture & Design. This session introduces the fundamentals of MOSS Farm design including server roles, topology constraints and design goals which are paramount for delivery of a secure, available and scalable MOSS hosting platform. Each server roles’ unique characteristics will be covered with their associated trade-offs. In addition, three common models will be presented with a discussion of their strengths and weaknesses. 20 minute food and drinks break 2nd Presentatoin: Top 10 Tips for your SharePoint Development Environment. This session will present 10 essential tips, tricks,...
  • How to submit your templates to Microsoft for inclusion in the Office Template site

    I saw this and thought it was amazing. If you have a template that is good and you want to make it available to others, simply package it up (save it without personal information in it) and pop along to this site ( https://services.office.microsoft.com/en-us/templates/submission.aspx ) to post it. I like this - power to the people!! ttfn David Technorati Tags: Office 2007 , Templates , Community
  • Application news for developers - x64 support, application people ready assessments, Vista Gadget security inspection and SharePoint development

    While I am on holiday I thought I would forward these items for the developers out there. The http://blogs.iis.net blog looks awesome for IIS7 information, including videos and the other MSDN information demonstrates how to develop SharePoint tools. Application support Is Your Application Platform People-Ready? Complete the Self-Assessment and Find Out Take the Application Platform Infrastructure Optimisation assessment to measure the effectiveness of your current infrastructure in platform-agnostic terms, and compare your application platform infrastructure against industry best practices and the latest IT research. http://www.microsoft.com/business/peopleready/appplat/ac/apio.mspx Inspect Your Gadget http://msdn2.microsoft.com/en-us/security/bb498012.aspx Today, the Windows Vista Sidebar hosts Gadgets built from HTML, JavaScript, and potentially ActiveX controls. Because Gadgets are HTML, they are subject to Cross-site Scripting style bugs. These bugs are extremely serious because script in the Sidebar is capable...
  • SharePoint webcasts, business information, KB support information and developer information

    When I talk to partners delivering solutions on Windows SharePoint Services V2, V3 and even for some Portal server is becoming a real business opportunity. When I met with Vin of Wem & Co the other day, some of the stuff they were doing was amazing! Anyway, here are the 3 things I thought might be useful - one being the SharePoint VHD so you can just download and play. SharePoint information Creating Business Value through Better Collaboration http://www.microsoft.com/downloads/Browse.aspx?DisplayLang=en&nr=20&productId=353C4E9D-9E78-4435-A360-01BB7F540D17&sortCriteria=date Tools Office SharePoint Server 2007 VHD This download comes as a pre-configured VHD. This download enables you evaluate Microsoft Office SharePoint Server 2007. http://www.microsoft.com/downloads/Browse.aspx?DisplayLang=en&nr=20&productId=353C4E9D-9E78-4435-A360-01BB7F540D17&sortCriteria=date Webcasts TechNet Webcast: Workflow in Microsoft SharePoint Products and Technologies 2007: Out-of-the-Box and Creating Custom...
  • How do I take a public folder offline

    I seem to have been asked this a number of times recently, so here is the answer. To take a public folder offline, simply add it to your favourites and then enable synching of public folders. Mark the public folder as a favourite (right click on the folder and select make favourite Go into your account settings and ensure that public folders are enabled for caching Tools / Account / Properties for the Exchange Account / More Settings / Advanced - then tick the box Now, when you sync the favourite public folders will be copied too. That is it ttfn David Technorati Tags: Offline , Public Folders
  • Questions from today's Webcast

    I promised to load the questions from todays webcast. The blog on the webcast can be found at Slides from todays Webcast on Windows SharePoint Services on SBS (WSS v2 & WSS v3) . The Questions were: Do uploaded files take up space in the system partition or can they be stored in a different partition They can do - all files are stored in the SQL database, so moving the SQL database will move the files from the system partition. if the existing SharePoint 2 is almost empty - will you loose out anything if you upgrade? Don't upgrade it - do a clean install and then move data across Do you recommend any books for end-user/creators? If you do this search, you can see a couple of books http://search.live.com/results.aspx?q=windows+sharepoint+services+book+sbs&src=IE-SearchBox - some people seem to rate the step by step book. You have a contacts list, can a specific detailed with field relevant to my business be created? Any fields can be added or removed from the WSS contacts fields, so yes, you can create...
  • Slides from todays Webcast on Windows SharePoint Services on SBS (WSS v2 & WSS v3)

    Today I did my last Webcast on SBS. It was the 3rd of a 3 parter on SBS. Part 1 was about how to use the OPK, part 2 was on Configuring SBS. I will post links to part 1 & 2 later today, but thought I would get the last one out 1st. If you watched the Webcast you will know that explorer crashed on my machine stopping the demos with word and excel working, which was not desired, but I did load 2 beta patches onto my system yesterday, so now the diagnosis as to wether that was the problem begins. Anyway, if you want the slides set they can be found here . Some of the useful links from the deck are: WSS v2 Office 2003 web parts (the last ones) http://www.microsoft.com/downloads/details.aspx?familyid=38be67a5-2056-46a1-84b1-337ffb549c5c&displaylang=en Samples and information http://www.sharepointcustomization.com/wss/articles.htm Enable Office 2007 support http://uksbsguy.com/blogs/doverton/archive/2007/03/13/how-to-get-companyweb-windows-sharepoint-services-v2-to-work-with-office-2007.aspx Backup and restore...
  • Simple overview of what is in Windows SharePoint Services 2007 & MOSS 2007 and how to develop on them

    For those who wish to expand into SharePoint enhancements (remember that you can enhance the site without any dev tools using the browser features) I found this simple blog entry ( Know your options for developing with SharePoint 2007 - Program - .Net - Builder AU ) and it is quite nice. Read the whole blog, but here is a snippet. The editions of SharePoint One of the more confusing aspects of SharePoint is that there are two versions available: Windows SharePoint Services (WSS) 3.0 and Microsoft Office SharePoint Server (MOSS) 2007. Developers follow the same basic steps to get started with SharePoint regardless of the version. Here's an overview of both offerings. |> WSS: This is the so-called "free" version, as there are no additional licensing issues. It is included with the Windows Server 2003 operating system (version 2.0). The current 3.0 version is available via download. It provides core document management, collaboration, and search functions, which include blogs, wikis, RSS feeds, e...
  • Upgrading to Office 2007 using retail boxes - what can you upgrade from

    [updated to change blog title to something meaningful] I was asked about this today - for those people with retail copies of Office, what can they upgrade from to Office 2007. Full details on Word, Excel, Access, Publisher and the suites can be found at 2007 Microsoft Office system pricing - Products - Microsoft Office Online . To see if you have a retail box of an earlier version of Office and if it will load without you needing to upgrade onto a new machine with Vista, have a look at http://uksbsguy.com/blogs/doverton/archive/2007/05/09/buying-vista-and-then-installing-an-old-version-of-office-whatare-you-allowed-to-do.aspx 2007 Microsoft Office suites 2007 Microsoft Office Suites Estimated Retail Price /Upgrade Price Qualifying Products for Upgrade Microsoft Office Basic 2007 Available only through OEMs; price not quoted Upgrade not applicable. Microsoft Office Home and Student 2007 $149/NA Upgrade not applicable. Microsoft Office Standard 2007 $399/$239 Microsoft Works 6.0–10; Microsoft Works suite 2000–2006...
  • How to enable cached mode for Outlook when used inside Terminal Server (which means that BCM can work too)

    OK, this is in response to the people who have posted on this subject. Someone was kind enough to give me the exact details, but I shall protect my sources except to say they know the insides of MS tools well. The warning here is that this is unsupported and could completely destroy your users profiles, so only do this is you are comfortable editing the registry The short description: Open up Regedit navigate to [HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\<ProfileName>\13dbb0c8aa05101a9bb000aa002fc45a] Find the key 00036601 (REG_BINARY) - note the number in it now so you can undo the changes if needed Change the value to one of the following enabled value; 84 01 00 00 - note that on my desktop system the enabled value is 84 19 00 00, so play around with this a little enabled with Public Folders/Favorites: 84 05 00 00 disabled value; 04 00 00 00 FYI - you will need to search for "00036601" and adjust ALL of them since each key is for a different user on...
  • Business Contact Manager 2007 (BCM) is NOT supported on Windows Terminal Server, but a little hack will make it work

    [updated on 28th July] Hi, I've pinged this around a bit internally and the answer I got back is that this is not supported and will not work. I have not tried it myself, but don't expect it to work. If you need this sort of functionality you need to look at MS-CRM I am afraid. History: You need a Volume License of Office 2007 to run in Terminal Services. You can get BCM with Volume Licensing of Office 2007 as noted at http://office.microsoft.com/en-gb/suites/FX101635841033.aspx Outlook running in Terminal Services does not run in cached mode - http://technet2.microsoft.com/Office/en-us/library/ba930d00-dc38-4564-ad00-8304d74f1d8c1033.mspx?mfr=true 3) BCM requires Outlook to run in cached mode (Office 2003 note in a KB about this - http://support.microsoft.com/kb/831747/en-us and I have had PSS confirm this is still the case with BCM and Office 2007) Wish this was not the case, but better to say up front rather than pretend. Now, updated, if you look at How to enable cached mode for Outlook when used inside...
  • Unified Communications

    This information is from the last 2 Technet newsletters ( http://www.microsoft.com/technet ) Unified Communications Team Blog http://blogs.technet.com/uc/default.aspx Unified Communications - Office Communication Server 2007 Videos Two videos, one on Office Communications Server 2007 and one on Office RoundTable http://www.microsoft.com/downloads/info.aspx?na=22&p=4&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d67d3e846-ae4a-4b30-9e0c-eac22bd2a58a%26DisplayLang%3den Unified Communications and Collaboration Event Presentation Downloads Unified Communications and Collaborations Event Downloads http://www.microsoft.com/downloads/info.aspx?na=22&p=5&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3da10931b2-dceb-4ddc-8c5a-25c4b2c5804c%26DisplayLang%3den Using Exchange Server 2007 for Unified Messaging and Fax How can you best implement the Unified Messaging (UM) features of Exchange Server 2007...
  • Windows SharePoint Services (WSS) v3, SharePoint Portal and Office Communicator, Partner Sales 101 and Dynamics and CRM training

    Office Communications Server 2007 Ignite Workshop This two-day workshop introduces many of the new features and capabilities that are built into Microsoft Office Communications Server 2007, including Rich Presence, Instant Messaging, Audio/Video Conferencing, and Voice. Click here to enrol. Implementing and Maintaining Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 Course This is a residential, intensive and compressed course intended for those partners who want to get a head start on the new SharePoint certifications. Ten days compressed into five Training for 12+ hours a day Residential course, with 24 hour availability of labs and instructor Exams taken during the week Limited number of seats – few deliveries are planned, so if you want your Partners to attend please encourage them to sign up now Click here for more information or to enrol Partner Sales 101 The next one is being held on the 11 th September 2007 Aim: This session will equip sales people with the knowledge and skills...
  • Show Classic Menus and Toolbars on Ribbon of Office 2007 - two product choices

    I saw a blog entry at Susan Bradley's blog about her now deploying Office 2007 with a classic menu . It was worth of a blog link for all those who want to stick to the old, old ways where you search for items over multiple menus (especially if you turn on personalised menus which hide all the things you don't use regularly). The tool looks slick, but then I found a 2nd one are realised that some cunning ISVs had seen this as their great opportunity to fill a gap that is very unlikely to be filled by Microsoft. The Two solutions are shown below and can be linked to from pschmid.net - RibbonCustomizer™ Feature Tour - Part 3: Classic UI Tabs and Show Classic Menus and Toolbars on Ribbon of Office 2007 : V1.1 Feature Tour - Part 3: Classic UI Tabs RibbonCustomizer™ V1.1 ships with a set of Classic UI tabs for Excel, PowerPoint and Word 2007. Those tabs emulate the Office 2003 menus and toolbars in Office 2007. We provide these tabs to help you familiarize yourself faster with the new Ribbon User Interface...
  • How to get rid of the installer / configuration dialog when running Office 2007 and Office 2003 on the same system - for Vista and other versions of Windows

    I have been asked this many times following up on the blog entry Installing Office 2003 and Office 2007 on the same system where once people have removed the problem with the End User Licensing Agreement (EULA) appearing every time they start Office they then get the dialogs below every time they switch between Word 2007 and Word 2003. when starting Word 2003 when starting Word 2007 The fix to the problem is very simple as it turns out - simply run the following commands (by pressing the Windows Key+R or typing it into the Start/Run command box. Use the line with Office\11.0 if you have Office 2003 installed and Office\12.0 if you have Office 2007 installed. You can use both if you have both installed : reg add HKCU\Software\Microsoft\Office\11.0\Word\Options /v NoReReg /t REG_DWORD /d 1 reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1 That is it. Office 2007 might want to have one more spin round the block with it's configuration dialog box, but that should be it. ttfn...
  • Why should a small business use Office 2007

    Once again I thought I would put pen to e-paper on the top reasons I give people to move to Office 2007. I don't think there are many businesses out there that use a PC and don't use some form of office productivity suite and while most use Microsoft Office XX (where XX could be 97, 2000, XP or 2003), some use other products that in my opinion just don't compare for a business that wants to look great and work efficiently. With Office offering a massive choice of products and features, these are the headlines I use when talking to people. For those with a version of Microsoft Office, but not 2007 More Professional and Impressive documents and materials Use Microsoft Publisher 2007 to build sales and marketing materials that look agency made, but are actually in-house work The updated Microsoft Word 2007 has many features to ensure your documents have a professional, consistent look and feel throughout the whole document conforming to your brand goals (no matter how big or small they might be). The...
  • How to find and use an Accounting template to use with Office Excel 2007 and then change it from US to UK currency, change the formatting of dates and drag lists (or Excel Tips and Tricks 1) - all in a Video presented with Silverlight

    The Video I have delivered a number of Vista and Office demos over my time, so I decided to record a number of them for others to borrow, use, learn from or anything else they choose. This video covers the following subjects in enough detail for people to hopefully understand what they need to know on how to use these features in Excel 2007 and apply them to all of the Office 2007 applications: Find a template and use it - I use an accounting template as it is based on Office 2003 and US based Change the currency cells from dollars to pounds using find and replace for formatting Change the date formatting from US to UK Dragging a list across a range of cells to give column a different month To see the Excel 2007 Video played using Silverlight (just try it) click here *. If you want to download it as a WMV file then head over to the new bCentral - the UK Small Business Center on MS.com - It is on this page as an Excel Accounting sample: * it will take a few moments to open if you have Silverlight installed and...
  • How to connect to and import data from an XML Web Service into Excel 2007

    I have been wondering how to do this recently for one of my own projects and then the subject came up internally. A very unassuming Hovsep then wrote up the answer, so as a tip here it is - if you follow the link at the bottom you will see a step by step process with screen shots to help you along the way. Excel 2007 - How to connect to and import data from an XML Web Service Many organizations have adopted a Service-Oriented Architecture (SOA) as the architecture of choice. SOA allows a company to expose its services and data in a manner that is compliant with industry standards. SOA is the buzzword these days. Down the wire of SOA is XML data that is exchanged between entities. Microsoft Office Excel 2007 has built-in features that allow a user to connect to and consume XML data. Such data can be stored in an XML file on the local hard drive, shared in a portal or returned from an XML Web Service. If you’d like to use Excel to import XML data from a Web Service, follow these step-by-step guidelines. For the...

(c)David Overton 2006-18