DavidOverton.com
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.  
David Overton's Blog » All Tags » Office 2007 » Support and Tools » Office System (RSS)

Browse by Tags

  • Office Live Workspace Update for Windows Vista to enable "Open From" and "Save to" menu items in Office Word, Excel and PowerPoint

    One little feature that others might have missed with the new release of Office Live Workspace is the two nifty buttons for Office to enable direct access from the Office Live Workspace Update for Windows Vista The Office Live Workspace Update installs three Windows Vista updates (KB945435, KB945145, KB933860) and one Office 2007 update to ensure optimal performance on Windows Vista when using Microsoft Office Word, Excel, and PowerPoint with Office Live Workspace. The update improves the performance of opening and saving Workspace documents from these Office programs. In some cases, the update also resolves problems with "Open from Office Live" and "Save to Office Live" functions of the Office Live Add-in . This update is only needed for computers running Windows Vista. Download details: Office Live Workspace Update for Windows Vista ttfn David Technorati Tags: Live , Office Live Small Business , Office Live , Office Live Workspace , Vista , Windows Vista , Save to , Open From

  • Latest news, events and downloads in the Security world from Microsoft - Windows Server 2008, Mobile, employee habits, Antigen, IPSEC, ForeFront, NAP, XP Firewall, System Center

    Each month the TRM blog product this great summary of the Microsoft world in various product areas. The blog can be found here http://blogs.technet.com/trm/ News Help your customers securely deploy Windows Server 2008 with the Windows Server 2008 Security Guide! http://go.microsoft.com/fwlink/?LinkId=92550 Every day, adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees. Your customers are looking to Microsoft and Windows Server® 2008 to help them address these threats. To assist customers in taking full advantage of the rich security features in Windows Server 2008, Microsoft has developed the Windows Server 2008 Security Guide. The Windows Server 2008 Security Guide provides IT professionals with best practices, predefined security templates, and an automated deployment tool to help strengthen the security of servers running Windows Server 2008. Supporting Your Family, Friends, and Neighbours...

  • More ways to engage with customers using the Microsoft advertising campaigns

    [updated 4th March] Many people congratulated Microsoft after the Mr Busy campaigns allowed partners to drive their customers back to them using a MS campaign. Well, this is now being repeated for a number of campaigns. Today I found the click and go site to get them all ( http://www.campaigns.arvato-services.com/ ). You can get 200 post cards or 1,000 e-mails for free and then a low price for additional cards/ e-mails if required. The campaigns covered include: Business Productivity Customer Acquisition and Retention Security and Reliability Small Business PC Mr Busy This method of engaging is not new to the Small Business team and others have covered this before (eg Susanne here ), but it is worth re-highlighting this now as some of the campaigns have been renewed, so go back and visit the site!! ttfn David Technorati Tags: Microsoft , Marketing , Campaigns , Business Productivity , Customer Acquisition and Retention , Security and Reliability , Small Business PC , Mr Busy , Partner , SME , Small Business Server...

  • How to Disable Internet features of Office 2007

    I saw this go around on a thread at work and I have seen it requested for those security conscious partners, so here is the answer (courtesy of Eric Ellis): 1) Via the Office Customisation Tool (OCT) and a custom MSP: — or — 2) Via Group Policy: The difference between the two is that using the OCT will preset the desired configuration during the initial installation (or in a maintenance mode change), but users can change the settings if they desire. Group policy enforces the desired configuration, and if a user makes a change to the setting, they will revert back to the settings defined in the policy during the next application session. ttfn David Technorati Tags: Office 2007 , Security , Internet , Group Policy , Office Customisation Tool , OCT

  • Do you want a Microsoft Architecture Poster?

    I saw this at Chris's site and thought I would share: Chris Bowen's Blog : Got Tech Posters? There are plenty of technology posters and charts for developers available on MSDN. I didn't realize just how many until I searched for "poster" on MSDN downloads . Here's a list of the more recent ones: [Edited list by David - more on Chris's blog] .NET 3.5 Namespaces Poster The .NET Framework 3.5 Common Namespaces and Types Poster Exchange Component Architecture Poster This poster highlights the architecture and feature set of Microsoft Exchange Server 2007. Visual Basic 2008 Keybinding Poster Printable wall poster containing list of useful keyboard shortcuts for Visual Basic 2008 developers Visual C++ 2008 Keybinding Poster List of keybindings for Visual C++ language within Visual Studio and Visual C++ Express 2008 Visual C# 2008 Poster Wall chart showing useful keyboard shortcuts for Visual C# programming language 2007 Office System: Developer Posters Download these posters to learn more...

  • Office 2007 SP1 is here and it does more than just update the desktop - SharePoint gets AJAX for example

    I'm sure you have heard that the Office 2007 Service Pack is here. Darren Strange has documented what is in it and how to get it at Office 2007 sp1 ready for download today and OfficeRocker! : More detail about sp1 . In answer to Susanne's post at here , hopefully this post has some more info in it One of the little things he puts that I like is: Some other factoids about sp1 There are roughly 2500 fixes in SP1. This an average size for a service pack, but the issues fixed are very important to our customers. Almost 20% of those fixes are direct result of customer requests. Over 500 of those fixes focused on security. There are a total of 24 different releases in 38 languages. There are 683 distinct packages. All have released simultaneously today. If you get the whitepaper then you would be keen to see the information below. Notice that SharePoint amongst other things a developer update to support Ajax and that other server products (Groove and Project Server) are also updated. Stability Microsoft continues...

  • Things that have fixed peoples problem running Office on Vista

    From the blog entry I published on 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 still get people e-mailing me with problems. While I have not been able to solve them all, but here are some solutions that I have seen success with: Problem: POP3 e-mail starts sending then gets stuck/hangs/stops: I have seen your blog at uksbsguy.com and it seems you are my only hope. Brand new laptop, small sized PST file, Vista Home Premium, Outlook 2007 Ultimate. I set up an account in Outlook 2007 to my bog standard POP3 account that has always worked. It starts to download my first email and slowly reaches 3 or 4KB then just hangs . Surprisingly I can sent (SMTP) absolutely fine. If I use another internet connection (dial up modem) instead of LAN then I can receive POP3 as well. But the same LAN connection works for my old laptop (XP/Outlook 2003) all settings same. I also tried the netsh command and the result is...

  • How to turn on e-mail logging in Office 2007 and ensure that your ports are open

    I was asked about this a while back and thought I would share. This person has e-mail receiving problems, so I wanted to turn on logging and check that the network ports were really open on his PC: To get a mail log for more details – go to Tools/Options – then the advanced tab/Other button/Enable logging. (mine is not checked – put a tick in yours). The location of the log file can be found at: MAPI (Exchange), POP3, and SMTP transports - The log file has the name OPMLog.log and is located in one of the following locations: c:\Users\ user name \AppData\Local\Temp\Outlook Logging - note this is the location on Windows VISTA You might also want to look at http://www.webpipe.net/howto/Outlook_0x800CCC0E . You will need to install at telnet, but this is documented as: By default, Telnet is not installed with Windows, but you can install it by following the steps below. To install Telnet Client 1. Click the Start button , click Control Panel, click Programs, and then click Turn Windows features on or off. If you are...

  • Download the "How to Sell, Deploy, and Build Business with Microsoft Windows Sharepoint Services 3.0 and SBS 2003 R2" now

    I have been asked about this loads of times, but for those of you who want to know more about using WSS v3 and SBS 2003, the guide is finally here at http://www.microsoft.com/downloads/details.aspx?FamilyID=59acc518-023e-43c3-b8f3-378c5e387461 . How to Sell, Deploy, and Build Business with Microsoft Windows Sharepoint Services 3.0 and SBS 2003 R2 Partner tool to create solutions using Windows SharePoint Services 3.0 and Windows Small Business Server 2003 R2. File Name: Selling_WSS_and_SBS_Kit.zip Date Published: 11/15/2007 Overview A new partner enablement tool helps you create solutions using Windows SharePoint Services 3.0 and Windows Small Business Server 2003 R2. Access the toolkit’s resources—including a process cookbook, technical documentation and marketing materials—to learn how to build your business by selling and deploying customized solutions. ttfn David Technorati Tags: SBS 2003 R2 , SBSC , WSS v3 , WSS , SharePoint , Windows SharePoint Services

  • How to make Office 2007 always save in Office 97-2003 format

    This is another area I get a lot of questions, so I thought I would share the answer. While my person preference is to tell people to load the tools onto Office 2000/XP/2003 machines as documented at How to open Office 2007 (Word, Excel, and PowerPoint 2007) files on Office 2000, Office XP and Office 2003 by downloading the Microsoft Office Compatibility Pack for File Formats - David Overton's Blog for some people this is not an option. So, how do you force Office to save in the older format? If you want to do it to lots of machines then look at http://msmvps.com/blogs/bradley/archive/2007/07/14/default-save-as-doc-and-xls.aspx . If you want to do it on your own personal machine, try this: Go the the "Opal" or the round Office button, and select Word Options Then go to the save tab and choose the file format you want, so Word 97-2003 for .doc files. You need to do the save in Excel and PowerPoint to get those too do it too. ttfn David Technorati Tags: Office 2007 , Office 2003 , Office XP , Office...

  • MSDN Evaluation Center for Office system, Biztalk, SQL Server 2005/2008 and Windows Server 2008

    I just found the MSDN Evaluation Center online today to give you evaluation resources that you might develop against. These include BizTalk Server, Office Communication Server, Office Enterprise , SharePoint Server, SharePoint Designer, SQL Server 2005, 2008, Express 2005 SP2, Windows Server 2008. I've pasted much of the content, but all the download links etc are country specific, so I have removed those. Click on the link above to get to download this stuff! MSDN Evaluation Centre Welcome to the MSDN Evaluation Centre, the central location for all Microsoft developer product trials and beta evaluations. Try a product before you buy it or test the latest beta to see what is in store for the next release. Start at the beginning of the evaluation process and follow the new products as they go through to the final releases. Remember to check back often as new products will be added as they become available. As you evaluate your software, we'll provide you with comprehensive and relevant insights and information...

  • What is in Office Accounting for accountants... well, multiple account views, sharing, customisation and more, but it is not an practice management solution

    I saw that someone said on one of the online forums that there was not anything in Office Accounting for Accountants. I beg to differ. This product is not something that offers anywhere near the same capabilities of someone like Iris for Practice Management - it is not designed to do so, it is aimed at small businesses who want a simple to use accounting package and then a tool for accountants to simply extract and manage data from it. I am not an accountant, but Microsoft offer several areas for Accountants with Office Accounting: Ability to customise the product to brand it for a specific organisation, such as an accountant, ISV or partner Ability to monitor several people's accounts from the one place and gather updates via an secure online process (through Office Live) Client sends accounts to accountant, continues using them and then the changes are synchronised back from accountant without data loss Run payroll for multiple clients Single Journal entry with VAT that spans multiple dates, customers and...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...
1 2 3 Next >

(c)David Overton 2006-23