Skip Navigation LinksHome > SSW Standards > Better Software Suggestions > SSW Microsoft Office Suggestions

Red star Indicates important rule

Microsoft Office

  1. Highlight button

    Users of the Google Toolbar may be familiar with the Highlight option, which highlights all occurrences of the current search keywords in the current document. This is a very handy feature and it would be good to see it in all Microsoft Office applications as well.

    Office
    Figure: Google highlight option in use.
  2. Smart(er) Tags

    Microsoft Office applications allow you to control when Smart Tags are triggered by using 'recognizers'. The list of recognizers can be altered, in most cases through the AutoCorrect options dialog. (See screenshot of Word's AutoCorrect dialog below.)

    It would be good if the list box could allow the user to drill down each recognizer item and view sample data (e.g. for 'Dates' the sample data would be a date, such as '1/1/2003').

    There are two ways in which this could be implemented, namely:

    1. Show it just underneath each item when the item is expanded.
    2. Display a 'More...' button underneath each item, which will open a dialog that displays the sample data.
    Other
    Figure: Smart tag settings in Microsoft Word.
  3. Getting More Smart Tags

    Office could be improved in how it handles extending of its smart tag functionality.

    Currently adding a custom smart tag requires editing registry; this should not be necessary. It would be better to implement an 'Add Smart Tag' button to the Smart Tags tab of the AutoCorrect dialog. (See screenshot.)

    Also, the More Smart Tags button in this dialog should be implemented as a hyperlink, as it links directly to a page on the Microsoft website.

    Other
    Figure: Smart tag settings in Microsoft Word.
  4. Readable Settings Files

    It would be nice if Office stored all of its settings files in a readable format. For example, if the settings files were stored as XML, then the user could clearly see the settings that were applied, and also be able to import/export parts of the settings files themselves (this is different to the current system where you have an all-or-nothing approach to the import/export of settings).

    Setting Files
    Figure: Settings files are stored in binary format, they should be XML

    But what about invalid xml?

    Just give the user a message something like: "Someone has changed with the xml and now it is invalid. Reverting to default settings."

    Note: Have renamed the file to zzWord11.xml so that they can attempt to fix it if they want to.

  5. Automatic File Version Increment

    It would be really useful if Office documents (e.g. Word, Excel) would have an option to increment the file version every time a document is saved and closed.

    For example, if you opened
    Session1_ExtremeProgramming_Access97to2003_AdamCogan_v3.ppt,
    made a changed, saved and closed the document, the filename would update to
    Session1_ExtremeProgramming_Access97to2003_AdamCogan_v4.ppt.

    This would help ensure that the latest version is being used and that you can determine at a glance which version of a document is the newest.

  6. Load MRU (Most Recently Used) lists as a background process during Save or Delete

    During the process of saving a file to a machine, Microsoft Office applications will try to load recently used files.
    This can cause an unnecessary delay when the machine is not connected to the network that a previous project was saved on; after a certain period it times out and goes on to save the file.
    The temporary fix to this is regularly clearing the MRU lists.

    As stated by Microsoft Support, following these steps to clear MRU lists of Microsoft Access, Excel, PhotoDraw, PowerPoint, and Word:

    1. On the Tools menu, click Options, and then click the General tab.
    2. Clear the Recently used files check box, and then click OK.
    3. Figure: Example of clearing MRU lists in Microsoft Word
    4. On the Tools menu, click Options, and then click the General tab.
    5. Select the Recently used files check box, and then click OK.
    6. Figure: Example of checking MRU lists in Microsoft Word

    This is a common issue in a lot of applications; freezes are usually caused by trying to access a network resource that is not available. MRU processes should be executed as background threads so that they dont lock up the main UI and leave the developer waiting.

  7. Run Office 2003 and Office 2007 side by side on the same PC

    Why does the Office team not design you to run Office 2003 and Office 2007 side by side on the same PC?
    Seems a strange thing to not keep on shipping...

Microsoft Word

  1. Move to Folder Function

  2. Suggestion
    Figure: Please add a Move To Folder" function?like in Outlook
    Suggestion
  3. Make a Save As option for pictures

    Please add another menu item to this right click menu "Save As" just like Internet Explorer

    Save As
  4. Option to print the computer name when printing documents

    We should have a 'ComputerName' to show the computer name.

    Page Setup
    Figure: Word's Header and Footer fields

    Read the same request for Internet Explorer on our Microsoft Internet Explorer Suggestions.

  5. Option to choose a footer style When print document with multiple pages

    When print document with multiple pages - Please pop a message box with a question:
    "Would you like to choose a footer style so you have page numbers when you print?"

  6. Help me use Office's Quick Access Toolbar - Make our software learn

    I don't see users (aka knowledge workers) use the Quick Access Toolbar... I don't even see advanced users like developers use it.

    I think it would be great to have it automatically learn how we use the application and put shortcut commands there.

    Then encourage me to use the shortcut commands, by having it give a visual indication (eg. flash) when I use the normal slow menu.

    Get Quick Access Toolbar
    Figure: It would be great to see the Quick Access Toolbar grow from this...
    Find Quick Access Toolbar easier
    Figure: To this... automatically

    PS: I would also like to see it in VS.NET

  7. Office 2010 Hate the new UI - Print button should be bottom right

    My Feedback for Office 2010 team is...

    The Print button should be at the bottom right ?as the eye navigates down we have to look back up to hit Print

    I could be wrong, so I would love to know the logic behind this change.

    The print button should be on the top right.
  8. Spelling - Microsoft Word should pick up all spelling/grammar issues

    It is very important that Microsoft Word picks up all spelling/grammar issues. It may be one little bug, but more likely this bug could affect a lot of possible sentences.
    More and more people with English as their second language rely on this to make their emails professional.

    When you type a sentence using the verb in the singular form with the subject is in the plural form, "Spelling and Grammar Check" tool does not pick it up as an error unless you keep typing more words after that.
    E.g. "For documents that belongs on the inside..." should be "For documents that belong on the inside..."

    grammar mistake
    Figure: BUG ?Microsoft Word's Spelling and Grammar Check tool does not highlight the error if you have "..." at the end of the sentence.
    MS Word can't check this word correctly.
    Figure: BUG ?Microsoft Word's Spelling and Grammar Check tool can't pick up some correct words.

    Note: We also rely on this with our Do you use Microsoft Word's spelling and grammar checker to make your web content professional? rule.

  9. Spelling - Add 'sms' to spell check

    Add Word To Library
    Figure: these 2 words need to be added to the spell check library, or include specific suggestions to fix
  10. Grammar - Add to grammar checker

    Add to grammar checker
    Figure: Another incorrect suggestion
    Add to grammar checker
    Figure: Another incorrect suggestion

Microsoft Excel

  1. Confusing Save Dialog ( Has been fixed already.)

    Before closing, Excel prompts the user to save any unsaved documents. Sometimes the wrong sheet is shown behind the save dialog; this can be very confusing.

    Excel Interface
    Figure: Confusing Save prompt in Excel.
  2. Excel to support Import Data from Web Services

    In Excel 2007 and 2010, it supports importing data from various data sources, e.g. SQL Server, Analysis Services, etc. But it does not support importing data from "Web Services". Importing data from Web Services functionality is great to have, so it will save user time to write VSTO code or VBA code to call web services.

    There isn't a 'Web Services' option.
    Figure: Adding Import from Web Services functionality
    Related link

Microsoft Access

  1. Access to support Import Data from Web Services

    Sometime, users may want to get data from Web Services provided by other party. It is a bit cumbersome to do at the moment, since Access 2007 and 2010 does not support importing data from Web Services. Users may need to write VSTO code and VBA code to call the web services. It will be very helpful if Access supports importing data from Web Services.

    There isn't a 'Web Services' option.
    Figure: Adding Import from Web Services functionality
    Related link

Microsoft FrontPage

  1. Why can't I add custom tag's to the FrontPage validator?

    In Tools - Page Options, users should be able to add custom tags. (eg missing span). Currently I need to switch to Dreamweaver to use this functionality.

    Frontpage
    Figure: Not in Front Page 2002...
    Frontpage
    Figure: ...nor in Front Page 2003 Beta 2

  2. FrontPage should support ASPX and ASCX files. (Thank you. Fixed in FrontPage 2003 Beta 2)

    In the Normal view there should be a GUI component to show a reference to an aspx include file - currently it is too easy to delete code like this (because you dont see it in the designer).

    Frontpage
  3. Where is the strikethrough option? (it is in Word)

    Right click the menu - Customize. No Strikethough option to drag onto the toolbar.

    Frontpage
    Figure: Strikethrough command does not appear in the list
  4. Move a picture from here please

    Need a button under "Browse...", named "Move" picture and when I click it, it defaults to CurrentFolderOfPage/Images/..

    Frontpage
    Figure: No 'Move...' button here.
  5. Captions For Images

    Microsoft Word currently supports attaching captions to embedded images, as seen in the following screenshot. This cannot be done with embedded images in Microsoft FrontPage, however. It would be useful if users could add captions to FrontPage images as well.

    other
    Figure: Microsoft Word's image pop-up menu includes Caption command.
  6. CSS comments

    This is clearly a comment and Show Color Coding is checked on, yet the comments are not in green like all other Microsoft development environments.

    Frontpage
    Figure: Comment text not green, even while 'Show Color Coding' is checked.
  7. MailTo: Links

    The mailto: link supports a body parameter. This should be editable in the hyperlink dialog.

    Frontpage
    Figure: Body parameter not allowed.
  8. Last Saved By

    I love editing web pages using FrontPage directly from Internet Explorer. However doing it this way can cause concurrent editing problems, as it doesn't recognise which user is making the changes. You can see that the the "saved to the server by ..." field is blank. You don't get this problem if you open the file in FrontPage from Windows Explorer directly. Unfortunately there is no work-around to this bug.

    Last saved by
    Figure: Editing in FrontPage from Internet Explorer potential causes concurrent editing problems

Microsoft PowerPoint

  1. Captions for images

    Microsoft Word currently supports attaching captions to embedded images, as seen in the following screenshot. This cannot be done with embedded images in Microsoft PowerPoint, however. It would be useful if users could add captions to PowerPoint images as well.

    other
    Figure: Microsoft Word's image pop-up menu includes Caption command.
  2. Help me understand PowerPoint 2010 disabled options

    The disabled options have me confused?

    1. Change the source file (from the original .avi you selected)
    2. Change the starting point (say start at 30 seconds)

    I can see that those toolbar options are disabled (below) but I cannot see the reason.

    You'll find the option disabled when you right click on the video
    Figure: Why can't I 'Trim Video' but others can http://www.dkszone.net/how-to-embed-format-and-edit-videos-in
    The option is disabled on the toolbar
    Figure: Why are these options in the toolbar disabled?
    Other related resources that did not help:
    1. http://techie-buzz.com/office-2010/embed-videosaudio-in-powerpoint-2010-presentations.html
    2. http://office2010.microsoft.com/en-au/powerpoint-help/what-s-new-in-powerpoint-2010-HA010336563.aspx
  3. Check for template updates

    If you have a PowerPoint using an older version of a template and want to:

    1. See what version you are using
    2. Migrate to the latest version

    Can I not have an option to 'Check for Updates' for the template, instead of starting a fresh new PowerPoint and importing the slides over?

    Figure: Why can't we check for layout updates?
  4. Add default ticks and crosses

    We have a Rule on using ticks and crosses for bullet points but currently we have to map to an image as a bullet point and it is a long, frustrating process.

    Why not have default ticks and crosses available?

    Figure: There is a default tick available but we need a cross as well

Microsoft Outlook

  1. OutLook Time Zone

    Outlook currenly uses 12 AM to 12 PM for All Day Events. This creates problem when it is for different time zone.

    It would be useful to use additional time zone feature in outlook to display local time zone without changing time of operating system. Either you can change all day event to local time zone setting.

    One best option to handle with this problem is storing all time zone using UTC(Universal Cordinated Time) so that there is no need for any other time settings and appointment can be rendered using local time zone.

  2. Change "All Day Appointment" to be an all day appointment

    Currently Outlook uses 12AM to 12PM to signify a full-day event - this causes problems when you change time zones.

    A full-day event is a full-day event, no matter what time zone your are in.

    Ken Getz says more on this:
    Time Zone Disaster--All Outlook Appointments Bite the Dust

  3. Image size

    When I put pictures into an Outlook HTML email, they are much less quality and significantly larger, even though Outlook reports that they are 100%.

    More information at: More Outlook HTML Email Problems

Acknowledgements

Adam Cogan