Wednesday, September 26, 2007

Excel 2007 Calculation Bug!

Microsoft has confirmed that Excel 2007 incorrectly displays the result of a calculation in 12 specific cases where a result should equal around 65,535. The issue is not in the calculation itself but in the result that is shown in the sheet.

For example, =850*77.1 will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer (i.e. if A1 contains “=850*77.1”, and A2 contains “=A1*2”, A2 will return the correct answer of 131,070).

A patch is in the works. More

Friday, September 21, 2007

Office 2007 White Papers: Digital Signing and The New GUI

2007 Office System Document: Digital Signing of Microsoft 2007 Office System Documents The 2007 Microsoft Office system provides many security improvements over its predecessors, including digital document signing. This white paper introduces the reader to digital signatures: what they are and how to use them.

2007 Office System Document: The Microsoft Office Fluent User Interface: Information Worker Perception of Productivity, Training, and Support Requirements This white paper presents the results of a Forrester Research study commissioned by Microsoft to help organizations and individuals understand the benefits of the Fluent user interface and address some of the challenges they may have in transitioning to Microsoft Office 2007.

2007 Office System Document: The Microsoft Office Fluent User Interface: IT Decision-Maker Perception of Productivity, Training, and Support Requirements This white paper presents the results of a Forrester Research study commissioned by Microsoft to help IT organizations considering Microsoft Office 2007 adoptions anticipate the impact of the new Fluent user interface on their end users.

Thursday, September 20, 2007

Custom RibbonX Reviewer for Access 2007


Click on the image to zoom in...

I am making available a free BETA of my Access 2007 RibbonX Reviewer for download. Make sure you read the readme file.

This is very much a stage 1 app, with the aim being in the next stage to deploy it as an add-in that will work inside the users' ACCDB, and eventually to provide in-place editing of Ribbonbars. I put the BETA out now, so that any bugs can identified before I go too far into the next stage.

Open the file RibbonXReview.accde in Access 2007 to review sample Access 2000 RibbonBars using the USysRibbons table.

Theres are also extensive reference resources incorporated into the GUI.

You can load your own USysRibbons table by importing it into the ACCDE and replacing the sample USysRibbons table.

Tuesday, September 18, 2007

Download Office 2003 Service Pack 3 (SP3)

Download Office 2003 Service Pack 3 (SP3). SP3 includes updated security and previously released hotfixes.

Some of the changes in Service Pack 3 modify the behavior of Office 2003, including changes that disable some features by default and increase control for computer administrators. Changes include:

  • Office 2003 can no longer open or save certain file formats. For more information, see Microsoft Knowledge Base Article 938810.
  • MAPI forms do not run in public folders and user folders. For more information, see Microsoft Knowledge Base Article 938816.
  • Office 2003 can now be configured to allow or deny specific COM components. For more information, see Microsoft Knowledge Base Article 938815.
  • Some COM components with unusual characteristics may not function as expected. For more information, see Microsoft Knowledge Base Article 938814.
  • Changes have been made to the behavior of Microsoft Office Document Imaging. For more information, see Microsoft Knowledge Base Article 938813.
  • Attachments with the .gadget extension can no longer be opened in Outlook. For more information, see Microsoft Knowledge Base Article 938811.
  • Access add-ins can no longer be configured for use by all users. For more information, see Microsoft Knowledge Base Article 938809.
  • The Fast Save setting in Microsoft Office Word has been removed. For more information, see Microsoft Knowledge Base Article 938808.
  • Documents saved in certain formats no longer contain the version number of Office. For more information, see Microsoft Knowledge Base Article 938807.
  • Certain macros in older Excel file formats have increased security. For more information, see Microsoft Knowledge Base Article 938806.

Known issues after you install Office 2003 SP3:

  • After you install a Microsoft Office service pack, you are prompted unexpectedly to restart the computer. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 905726 (http://support.microsoft.com/kb/905726/) You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update
  • After you install Office 2003 SP3, an add-in, ActiveX control, or COM add-in may not work as expected in an Office 2003 program. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938814 (http://support.microsoft.com/kb/938814/) The functionality of an add-in, an ActiveX control, or a COM add-in is reduced, or the functionality is blocked after you install Office 2003 Service Pack 3
  • After you install Office 2003 SP3, you may receive an error message when you try to create a new MAPI form in Outlook 2003. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938816 (http://support.microsoft.com/kb/938816/) Error message when you try to create a new MAPI form in Outlook 2003: "contact the administrator"
  • After you install Office 2003 SP3, attachments that contain the .gadget extension cannot be opened in Outlook 2003. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938811 (http://support.microsoft.com/kb/938811/) Attachments that contain the .gadget extension cannot be opened in Outlook 2003 after you install Office 2003 Service Pack 3
  • After you install Office 2003 SP3, the Fast Saves feature does not work as expected in Word 2003. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938808 (http://support.microsoft.com/kb/938808/) The Fast Saves feature in Word 2003 no longer functions after you install Office 2003 Service Pack 3
  • After you install Office 2003 SP3, the Microsoft Office Document Imaging program may not work as expected. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938813 (http://support.microsoft.com/kb/938813/) You may experience issues when you run the Microsoft Office Document Imaging program after you install Office 2003 Service Pack 3
  • After you install Office 2003 SP3, you may receive an error message when you try to open or to save a file. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 941636 (http://support.microsoft.com/kb/941636/) You receive an error message when you try to open a file or to save a file after you install Office 2003 Service Pack 3
  • After you install Office 2003 SP3, you cannot open some Microsoft Excel workbooks that contain Microsoft Visual Basic for Applications (VBA) macros. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938806 (http://support.microsoft.com/kb/938806/) You cannot open Microsoft Excel 5.0/95 Workbook files that contain Visual Basic for Applications macros in Excel 2003 after you install Office 2003 Service Pack 3
  • After you install Office 2003 SP3, the version number of Office is no longer saved in the properties of the document as expected. For more information about this issue, click the following article number to view the article in the Microsoft Knowledge Base: 938807 (http://support.microsoft.com/kb/938807/) Office files that are saved in certain formats no longer contain the version number of Office after you install Office 2003 Service Pack 3
Microsoft Office 2003 Service Pack 3 Available Tomorrow

Office 2003 SP3, promising improved security and enhanced compatibility with Windows Vista, Office 2007, Internet Explorer 7 and Windows SharePoint Services, will be available tomorrow (September 18, 2007). Source

Tuesday, September 11, 2007

Excel 2007 XLL Software Development Kit

Excel 2007 Download: Excel 2007 XLL Software Development Kit The Microsoft Office Excel XLL Software Development Kit (SDK) contains conceptual overviews, programming tasks, and sample projects to guide you in developing Excel 2007 XLLs.

Friday, September 07, 2007

Microsoft Visual Studio 2005 Tools for Office Second Edition Runtime

The Microsoft Visual Studio 2005 Tools for Office Second Edition (VSTO 2005 SE) redistributable package (build 8.0.50272.891) (x86) installs the Visual Studio Tools for Office runtime, which is required to run solutions built using VSTO 2005 or VSTO 2005 SE.