When trying to open or save an Excel file in a terminal services environment, you may encounter one or more of the following errors:

[Filename] is locked for editing by 'another user'

[Filename] cannot be accessd. The file may be corrupted, located on a server that is not responding, or read-only.

This can also happen when trying to open or save a Microsoft Word document in terminal services.

Running Process Monitor you may find that the the following location is being accessed unsuccessfully - "C:\Documents and Settings\%username%\Local Settings\Temp\1". If you try navigating to this folder manually, you may find that the "\1" subfolder doesn't exist. The Office documents are trying to save/access a temporary file from this location and are unable to do so.

The issue is that Terminal Services is using "temporary folders per session", as detailed here - "Temporary Folders". Basically, Terminal Services by default  creates a separate temporary folder for each active session that a user maintains on a remote computer. These temporary folders are created on the remote computer in a Temp folder under the user’s profile folder and are named with the "sessionid". In addition, the environment variables for TEMP and TMP are modified. The problem happens when the environment variables are modified but the actual temporary folder is never created. You can manually create the "C:\Documents and Settings\%username%\Local Settings\Temp\1" location, but after logging off and back on this folder may not exist.

To resolve this problem, run GPEDIT.MSC and navigate to Computer Configuration > Administrative Templates > Terminal Services and set the "Use temporary folders per session" to 'disabled'. This will prevent the environment variables from being modified and Office files should be able to save to the location you specify.

When trying to open an Excel file, you may run into the following error:

"The file you are trying to open, [filename], is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trustworthy source before opening the file. Do you want to open the file now?"

Clicking Yes to open the file, you may find that the content of the file is unreadable and contains unreadable characters and/or symbols.

This is an issue that can happen when Symantec Endpoint Protection is installed on the machine. To resolve the problem, update Symantec Endpoint Protection to the most recent version.

It ran a bit late, but the October cumulative update has been released for Office. Below are the links:

Office 2007 Cumulative Update for October 2012 - http://support.microsoft.com/kb/2757116

Office 2010 Cumulative Update for October 2012 - http://support.microsoft.com/kb/2757117

MS12-060 is a security update that was released Tuesday, August 14, 2012. This update replaced MS12-027. Some may be seeing "Unspecified Automation Error" when running your Microsoft Office VBA code after installing MS12-060.

The fix for the MSCOM control issue has been released to the download center. In addition, the KB articles have been updated with mention of the resolution and link to download the new package. 

Also mentioned is that you don’t need to install the original update in order to install the new update.

Office 2007
ttp://support.microsoft.com/KB/2687441

Office 2010
ttp://support.microsoft.com/KB/2597986

The Office Sustained Engineering Blog has also been updated with a resolution
http://blogs.technet.com/b/office_sustained_engineering/archive/2012/08/24/ms12-060-not-initiating-with-certain-controls.aspx

Pivot tables can be difficult enough to work with by themselves, but it's even more frustrating when Excel finds unreadable content in your workbook and strips the pivot table off the sheet. You may notice this problem after you refresh data in your pivot table, save the file, close it and then try to re-open it. Excel may present you the following error:

"Excel found unreadable content in '[Workbook Name]'. Do you want to recover the contents of the workbook? If you trust the source of the workbook, click Yes."

Clicking Yes to recover the workbook will likely get the workbook to open, but you may find that your pivot table is now a flattened collection of data and no longer a pivot table. This post examines one such cause of the problem and how to prevent it from occurring.

Pivot Tables get their data from the Pivot Cache. The Pivot Cache is a container that holds a static copy of your data. The ability to massage your data in the way you see fit comes from having maintained the source data beforehand in a static go-to container, the pivot-cache. It's what makes pivoting the data possible.

But the pivot cache doesn't like fields that contain a duplicate value when using unique records only, or a non-unique value. Take a date, for example. Excel has a lower bound date limit of 1/1/1900 as the earliest date. So if you were to use a date such as 5/31/1899, Excel wouldn't be able to handle the date and will revert it back to the earliest possible date that it can handle, which is 1/1/1900, assuming the 1904 data system is turned off. If you already had 1/1/1900 in the pivot table, and your date of 5/31/1899 is converted to 1/1/1900, you suddenly have a duplicate value. When saved this way and reopened, Excel runs a check that sees duplicate entry and treats it as a corrupted cache and hacks up the error that you see.

The workaround for this problem is to eliminate the duplicate entry from your data before saving the Excel file. This will satisfy the unique records requirement and Excel won't see the cache as being corrupt.

Thanks for the feedback the “available resources” post!  We realized that many people are getting these type of memory issues in Excel and are looking for some answers.  So we wrote a detailed KB that addresses most of the common memory issues.

If you are seeing any of the following messages;

• "Excel cannot complete this task with available resources. Choose less data or close other applications."
• “Out of Memory”
• "Not enough System Resources to Display Completely"

2779852 How to Troubleshooting Available Resources errors in Excel
http://support.microsoft.com/kb/2779852

When you embed another Excel file into an Excel 2007 or 2010 workbook, choosing only to show the icon for the file, you may find that after saving the Excel workbook that the icon text, picture or both text and picture is missing. In some cases the picture remains while the text is gone and in other cases only a blank white space is left, though it still works to open the embedded Office document when clicked. Here is what you would see:

In this case, the text is missing and the icon is blank.

This has been confirmed to happen when a third party program called Digital Guardian by Verdasys is installed on the system. The problem is known to happen with version 5.3.2 on the client and 5.3.1 on a server. Apparently this is a known issue that can be corrected by upgrading to version 6.1. Check with Verdasys if you are having trouble locating the update.

(Updated Dec 2013)

After installing the October 2013 update (KB 2825655) for Excel 2013,  PowerPivot is unable to be used.

Examples of errors you will receive when trying to work within existing PowerPivot workbooks or launching the PowerPivot Window to create a new one are below.

ERRORS:

 "We couldn't get data from the Data Model. Here's the error message we got: Invalid pointer array"

 "PowerPivot is unable to load the Data Model"

At this time, the only resolution to this issue is to uninstall update KB 2825655    http://support.microsoft.com/kb/2825655/EN-US

Microsoft is working on a resolution. Watch the blog for updates on when a fix is available for this issue.



*** UPDATE : Hotfix Available ***

To resolve this issue, you can request a hotfix from the link below.

Issue

While using a VPN connection with Office 2013, users have reported that they are unable to connect to the internet within Office, causing some Office 2013 functionality not to work as expected.

Scenarios we have seen include: 
1.   Word 2013 unable to insert online pictures

ERROR:  "You need an internet connection to insert online pictures"

2.  Office Account Connected Services shows no internet connectivity

ERROR:    "NO INTERNET CONNECTION  Connect to the Internet to add or manage services"

3.  Attempting to launch help via F1 will bring up the Help interface, but it will report that the client is not connected to the internet

4. Attempting to access SharePoint or Check Out Documents from SharePoint results in errors such as:

        "Cannot checkout any document on SharePoint 2013 without internet connection"
        "Unable to connect right now. Check network and try again"
   

Additional Symptoms:

Checking the status of the network adapters in the Windows Network and Sharing Center will show that the VPN adapter does not have internet access.

Cause

Two terms to define first:
NLA – Network Location Awareness
NCSI – Network Connection Status Indicator

Customers have reported this issue using VPN solutions from both Juniper Networks and Palo Alto Networks.  We are sure there are other VPN clients that we don’t know about that are also impacted.

There is a service running on each Windows 7 machine that is called “Network Location Awareness”.  This service is responsible for determining the state of the network connections on the machine.  The information about the network connections is stored and accessed by the service “Network List Manager”.   Applications like Office 2013 can implement the Network List Manager interface to be able to get the state of the computer network connections and what connectivity each adapter has.  This allows the application to simplify their code and simply “ask the OS” what the network state is. 

For the customer reported issues, the third party VPN clients in use happen to not define a default gateway.  This may display as a default gateway of 0.0.0.0 in the ipconfig output.  This is not really an issue for typical networking.  Customers may notice that they can get to network resources, and they do have connectivity to the internet.  The problem here is that NCSI depends on the default gateway to decide if it should “probe” the network connection to decide if it has an internet connection.  The way that NCSI probes the network is it attempts to connect to www.msftncsi.com and retrieve a file called ncsi.txt.  If it can retrieve that file, it marks the connection as having internet access.  When the VPN adapter connection connects, and NCSI detects that a connection was made on an adapter interface.  NCSI will attempt to probe the connection, but since there is no default gateway on the VPN adapter it attempts to send the probe packets out the adapter with a default gateway and that fails since the VPN connection is active.  When this probe attempt fails, NCSI marks the adapter as having LOCAL connectivity.  Office 2013 is checking for INTERNET connectivity before attempting to connect to the online functionality such as online pictures or F1 HELP resources.

Status
To resolve this issue, install the hotfix that is described in the article below.

2964643 Third-party VPN client stops Internet connectivity in Windows 7 SP1 or Windows Server 2008 R2 SP1
http://support.microsoft.com/kb/2964643/EN-US
 

After installing Office 2013 with Service Pack 1 from the Volume Licensing Service Center (VLSC) with a customized MSP file using the Office Customization Tool (OCT), Lync and OneDrive for Business are not installed.

This can also affect the Power Map and PowerPivot for Excel Add-ins 

Please review the following blog for workarounds and resolutions.

Lync 2013 and OneDrive for Business are not installed when installing Office 2013 with Service Pack 1

http://blogs.technet.com/b/odsupport/archive/2014/03/21/lync-2013-and-onedrive-for-business-are-not-installed-when-installing-office-2013-with-service-pack-1.aspx

Note: This only affects MSI installs

Guest Blogger: Harold Kless

If you try to edit an Office file (Word, PowerPoint or Excel) from a SharePoint 2010 Document Library while using an iPad with MS Office applications installed, the file will not open and there is an error “there is no SharePoint Foundation application available to open
the app.”

SharePoint 2010 requires a plugin or active X to launch client applications, and neither of those are allowed on the iOS platform. SharePoint 2013 and SharePoint Online support protocol handlers that work with iPad.

To work around this behavior:

Option 1 – Add a Place within the application that will connect to the SharePoint Document Library.

1. To do this open any of the installed Microsoft Office applications
   (Word, Excel or PowerPoint).
2. On the opening window choose Add a Place.
3. In the Add a Place window click on SharePoint Site URL
4. In the SharePoint URL window enter the url or internet address of the SharePoint Document Library.
5. Click Next - when prompted enter the username and password.

Option 2 – download a copy of the file

1. When in the Document Library click on Download a copy.
2. The document will be displayed in the browser window with the option to choose how to open in the appropriate application.
3. When the file opens it will be read only with the option to edit and save.

When opening an .xlsx file in Excel for iPad, Excel for Mac or Excel for iPhone, you receive an error.

ERROR: "The workbook you are trying to open is an ISO Strict file"

 - You find this does not happen with all .xlsx files

Cause:

The file that will not open was created or saved using the newer Strict Open XML Spreadsheet (.xlsx) file type. The ability to save Microsoft Office files in Strict Open XML format was introduced in Microsoft Office 2013 programs.

ISO Strict file is not supported on Excel for iPad, Excel for Mac or Excel for iPhone

See screenshot below, there are two options for . xlsx in Excel 2013 to save: 

 Excel Workbook (*.xlsx)  and  Strict Open XML Spreadsheet (*.xlsx)

References:

New file format options in the new Office
http://blogs.office.com/2012/08/13/new-file-format-options-in-the-new-office/

Why can’t I open my file?
http://office.microsoft.com/en-us/excel-help/why-cant-i-open-my-file-HA103748560.aspx

2960660 Strict Open XML files do not open or save in Excel for iPad or Excel for Mac
http://support.microsoft.com/kb/2960660/EN-US

As I read through the feedback on Excel 2013, it strikes me that many users are having a little trouble getting used to the interface changes, and are not aware of options to replace the things they miss in earlier versions of Excel. So here are a few tips and tricks to make your life easier!

Print Preview

We see a lot of people missing the old full-screen print preview. It’s still there! Just click on the Quick Access Toolbar (QAT) dropdown and go to More Commands. Add Print Preview (Full screen) to the QAT. Then you can go into the old-style Print Preview any time you like! Alternatively, if you have a custom group with your favorite commands on it, you can add print preview to that.

Others miss the ability to drag the margins in print preview to change them. True, when you first go to the Print backstage place, you don’t have the margins showing. But if you click on the left icon at the bottom right side of the page, you can toggle the margin indicators on and off. Once they are showing, you can drag the margins just like you could in the old-style print preview.

Opening Excel

If you just want to go to a new workbook when you first open Excel, you can do so by clearing the box that says "Show the start screen when this application starts." You will find that at the bottom of the General tab in Options.

Save and Open

Another frequent complaint is that people don’t want to bother with the backstage when they open or save files. There is an option for that… On the Options dialog box, under the File menu, click Save. Put a check in the box beside “Don’t show the Backstage when opening or saving files.” Then when you want to save, hold down Control and press S. Control+O when you want to open files. The common file dialog box comes right up.

While you are at it, if you don’t want to save to SharePoint or OneDrive by default, check “Save to Computer by default.”

Favorite Places

While Favorite Places still shows up in the common file dialog box, some people have mentioned that it isn’t there on the Backstage. They want to be able to add local folders under “Add a place.” Recent folders do show up after you click on the appropriate type of locations. But you can also pin locations to After you have saved to a location once, go to Save As… And find the place you want to save. Hover over it, and it will show a little push pin on the right. Click that, and that folder will always show up at the top of your list.

You can also pin documents to the "jump list" that comes up when you right-click the Excel taskbar icon. That comes in handy for people who miss being able to pin documents to the start menu from Windows 7.

 Freeze and Split Panes

Some folks have mentioned that they can’t find Split Panes now that the little control to drag to split is gone. It’s on the view menu. Place your active cell below and to the right of the point where you want the panes split. Click on the Split button on the View menu. Once the panes are split, you can drag them around to reposition.

People also seem to be confused about Freeze Panes. By default, if your active cell is in the first row, Freeze Panes (and Split) will be positioned in the middle of the visible cells. Place the active cell below and to the right of the freeze you want. Or if you want the top row or left column, click the Freeze Panes button and pick Top Row or First Column.

Sheet Navigation

People miss the first sheet, last sheet buttons beside the horizontal scroll bar. Did you know that you can right-click on the sheet navigation arrows to bring up a list of all the sheets? Then you can navigate directly to the one you want.

Hope this helps!

After editing the Internet Explorer settings via group policy, some users are experiencing errors when trying to launch the Office applications.

 ERROR Examples:

 "Word could not create the work file. Check the temp environment variable."

"Outlook could not create the work file. Check the temp environment variable."

Resolution:

When editing the group policy, ensure that the  Temporary Internet Files setting for "Current Location" is set correctly and/or is not blank.

Internet Options > General tab > Browsing History > Settings:

Windows 7 default:  C:\Users\%username%\AppData\Local\Microsoft\Windows\Temporary Internet Files

Windows 8 default:   C:\Users\%username%\AppData\Local\Microsoft\Windows\INetCache

Other known causes and resolutions of this error can be found in the Knowledge Base article: 

2285187 "Word could not create the work file" error message when you save a document in Word 2013, Word 2010 or in Office Word 2007
http://support.microsoft.com/kb/2285187/EN-US

We have seen reports of Excel documents hanging whenever trying to open a spreadsheet that uses Information Rights Management (IRM) after you apply MS12-057 or this hotfix: http://support.microsoft.com/kb/2687297. Additionally, the reports go on to say that a new file may hang when you try to apply IRM protection after installing this security update.

If you suspect you are running into this error, you should be able to resolve the problem by deleting all files in the following path:

%LOCALAPPDATA%\Microsoft\DRM

also, make sure to rename or delete the following registry key:

After installing MS12-030, when you load an Excel workbook you may see the following error message: "This build of Microsoft Office is unsigned and cannot be trusted by a production Windows Rights Management Servicies (RMS Server). Before using Information Rights Management (IRM) in this build, specify a test RMS server."

This problem is caused by some specific files in MS12-030 being codesigned using a certificate that was incorrectly configured. The issue can be fixed by installing the hotfix package from http://support.microsoft.com/kb/2598144

Repurposing a button in Excel is incredibly easy these days. To repurpose a button means to redefine what happens when you click the button. Want it to perform some action from a custom macro? Follow the steps below to find out how this is done.

1. Download the Custom UI Editor for Microsoft Office from http://openxmldeveloper.org/archive/2006/05/26/CustomUIeditor.aspx. The download on that page will be near the bottom, labeled "OfficeCustomUIEditorSetup.zip". This ZIP package contains an MSI file, which is an installation file.

2. Double click the MSI file included in the ZIP you just downloaded. This will install the Custom UI Editor.

3. After installation, run the Custom UI Editor. There are only three menu options - File, Edit and Insert. You will need an Excel file saved to your machine, so if you haven't got one already, launch Excel and create a new spreadsheet, then save it somewhere on your machine. For our purposes, we will call this fictional file buttontest.xlsx

4. In the Custom UI Editor, click File > Open. Navigate to where you saved the Excel file and click Open. You now see the name of your workbook in the left hand pane in the UI editor. Now click Insert > Sample XML > Repurpose.

Code is inserted into the main window. You will see the following:

 <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
      <commands>
           <command idMso="Bold" enabled="false"/>
           <command idMso="Save" onAction="MySave"/>
      </commands>
</customUI>

5. You can delete the line which reads:

<command idMso="Bold" enabled="false"/>

So all you are left with is

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
      <commands>

           <command idMso="Save" onAction="MySave"/>
      </commands>
</customUI>

6. Now you need the idMso name of the button you want to repurpose. Head on over to this page (http://msdn.microsoft.com/en-us/library/dd945681(v=office.12).aspx)to get the idMso of the button you need. For an example, let's say we want to repurpose the Copy menu item under Home. Your code would look like this:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
      <commands>

           <command idMso="Copy" onAction="MyCopy"/>
      </commands>
</customUI>

Notice the onAction item is pointing to something called MyCopy. What is that? Glad you asked. That's the subroutine name of the macro we're about to create.

Click File > Save in the Custom UI Editor and close it.

7. Open Excel and your spreadsheet. In my example it was named ButtonTest.xlsx. Inside the spreadsheet, hit ALT+F11 to open the VBA editor.

8. Click Insert > Module. A code module is inserted in the main window. Copy and paste the following code in your window:

Sub MyCopy(IRibbonContol, ByRef cancelDefault)

     msgbox "This is a test"

End Sub

9. Click File > Save filename.xlsx. You will be prompted that you now have a macro in the workbook. Click NO on the dialog and under the "Save as type" dialog select Excel macro Enabled Workbook (*.xlsm) and click Save.

10. Go back to the main Excel sheet. Click the Home tab and then click the Copy menu item. What you should see is this:

And that's all there is to it! In place of the messagebox you can add whatever code you want to add when clicking a button.

The hotfixes for the following updates as part of the October 2011 CU have been recalled. Two critical fixes that were supposed to be part of this CU were missing. The following hotfixes have been recalled:

http://support.microsoft.com/kb/2596535

http://support.microsoft.com/kb/2596538

http://support.microsoft.com/kb/2596539

http://support.microsoft.com/kb/2596545

These updates will be be-issued as soon as possible.

The Cumulative Updates (CUs) for October 2011 have been released. Here is a breakdown of the CUs released for Excel.

• KB article 2596535 (http://support.microsoft.com/kb/2596535) - You have a Word document that contains a text box and a picture. The text box overlays the picture. When you use a computer that has the 2007 Microsoft Office suite Service Pack 2 (SP2) installed to print the Word document in Office Word 2007, the document is printed incorrectly.
• KB article 2596538 (http://support.microsoft.com/kb/2596538) - The Camera tool performs slowly in Microsoft Office Excel 2007 when the zoom level is not set to 100% in a workbook. Additionally, Office Excel 2007 runs slowly when you open the workbook or move a shape in the workbook.
• KB article 2596539 (http://support.microsoft.com/kb/2596539) -
  • You apply the hotfix package that is provided in Microsoft Knowledge Base (KB) article 2544402 or KB article 2553026.
  • You open an existing .xls file from a network location.
  • You make some changes and save the file.
  In this scenario, you receive the following error message:
  The file 'FileName.xls' may have been changed by another user since you last saved it. In that case, what do you want to do?
• KB article 2596545 (http://support.microsoft.com/kb/2596545)-

  • Consider the following scenario:
    • The  ForceShellExecute registry entry is enabled in Windows.
      
      Note The ForceShellExecuteregistry entry is in the following registry key:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet
    • You click a hyperlink in an Excel 2007 workbook. The hyperlink links to another workbook.
    In this scenario, the linked workbook does not open. Additionally, the pointer remains as a busy pointer.
  • Consider the following scenario:
    • You have an Excel 2007 workbook that contains a shape. The shape references another workbook.
    • You try to copy the shape to another workbook. 
    In this scenario, Excel 2007 crashes.
  • When you print an Excel workbook in Excel 2007, the data in the workbook starts to be printed on the second page of the printout. Additionally, the columns on the second page are truncated.
    
    This issue occurs when the following conditions are true:
    • The paper size is set to A4 or Letter.
    • A "fit to page" option is selected.
    • The printout is more than one page and includes the title.
    • The printer supports scaling.
  • Assume that you have a workbook on a UNC share of a server. This workbook contains a link to another workbook on the same server. For example, the link contains the following path:
    \\server\share\folder\test
    However, after you install KB2587505 and then open the workbook that contains the link in Excel 2007, the path of the link is loaded incorrectly. For example, the path that the link contains is loaded as the following:
    \\server\share\share\folder\test
    Therefore, the link is broken.
    
    For more information about KB2587505, click the following article number to view the article in the Microsoft Knowledge Base:
    2587505                                         (http://support.microsoft.com/kb/2587505/                        )        MS11-072: Vulnerabilities in Microsoft Excel could allow remote code execution: September 13, 2011
  • When you try to create a list by importing an Excel 2007 workbook to a Microsoft Office SharePoint site, you receive the following error message in Excel 2007, and the import operation fails:
    Method 'Post' of object 'IOWSPostData' failed
    This issue occurs when the following conditions are true:
  • The ADFS service is running on the computer that you use to access the SharePoint site.
  • The computer is running a 32-Bit version of Windows 7.
  • You use Windows Internet Explorer to access the SharePoint site. The Check for server certificate revocation option is enabled in Internet Explorer

When you create a hyperlink to another Office document in Excel 2007 or 2010 and click to follow that hyperlink, you expect the document to open. In some cases, however, you may receive an error: "Cannot locate the Internet server or proxy server". A quick BING search reveals KB Article 218153 (http://support.microsoft.com/kb/218153). This article directs you to add the "ForceShellExecute" registry value to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Common\Internet. And this does take care of that problem. But then another arises.

You may find after applying the ForceShellExecute value that you aren't able to open a hyperlink to an Office document from Excel. Now instead of getting the error, nothing happens. You may get a spinning cursor that does nothing. Fear not! This problem is addressed in two KB Articles. If you're on Excel 2007 then you want to follow KB Article 2596545 (http://support.microsoft.com/kb/2596545) and obtain the hotfix therein which will fix this problem. If you're on Excel 2010, the hotfix is here (http://support.microsoft.com/kb/2597142). There are multiple fixes in this article but most notably is the one where Excel documents contain hyperlinks that do nothing when clicked.  In this article we change the way Excel handles DDE requests to open Office documents. And then after applying either of these fixes, there's one more annoyance that you may or may not be able to live with. You may receive this pop up each time you click the link:

While this dialog isn't a bug, it can certainly be annoying. To get rid of this dialog you need to set the following registry key accordingly:

1. Click START > RUN and type REGEDIT and click OK
2. Navigate to HKEY_CLASSES_ROOT\Excel.Sheet.12

(don’t let the 12 in the above fool you, this applies to Excel, 2010 as well)

On the right look for a value called “EditFlags” – this should be a REG_BINARY key type. Double click it. By default the value is 00 00 00 00 but you want to set it to 00 00 01 00

Once setting this value you will need to close Excel and re-open it. But this will only suppress the dialog for XLSX files. To make the dialog not show up for other files types, you would need to set the EditFlags value above to the following registry keys:

If the EditFlags key doesn’t exist it needs to be created – like under HKEY_CLASSES_ROOT\Excel.CSV - by default there isn’t an EditFlags value so it must be created. The following is a list of the file types and their corresponding registry keys:

XLSB - HKEY_CLASSES_ROOT\Excel.SheetBinaryMacroEnabled.12

XLT - HKEY_CLASSES_ROOT\Excel.Template.8

XLTM - HKEY_CLASSES_ROOT\Excel.TemplateMacroEnabled

XLAM - HKEY_CLASSES_ROOT\Excel.AddInMacroEnabled

XLA - HKEY_CLASSES_ROOT\Excel.Addin

CSV - HKEY_CLASSES_ROOT\Excel.CSV

ODS - HKEY_CLASSES_ROOT\Excel.OpenDocumentSpreadsheet.12

SLK - HKEY_CLASSES_ROOT\Excel.SLK

XLL - HKEY_CLASSES_ROOT\Excel.XLL

If you've ever used ActiveX controls on your Excel Spreadsheet you may have run into the problem of the control suddenly no longer working. When you open the workbook there's nothing but a big red X in the place of where your control used to be. The tree-view (treeview) control comes to mind, which may have stopped working after applying the fix in KB article 982308 (http://support.microsoft.com/kb/982308). Fret not, for there is a hotfix available to remedy this behavior. It is here - http://support.microsoft.com/kb/2483214. This will restore the treeview control to full working order.

Will

The cumulative update for Office 2007 and Office 2010 for February 2011 has been released! These updates can be found here:

Office 2007 CU for February 2011 (http://support.microsoft.com/kb/2493732) and the Office 2011 CU for February 2011 is here (http://support.microsoft.com/kb/2493730).

These releases includes the following KB articles:

There are fixes aplenty for Excel in Office 2010 Service Pack 1. You can download the patch from http://support.microsoft.com/kb/2460049. On this page you can choose to download the 32 or 64-bit version. This is dependent on the bit version of Office that you have, not the operating system bit version. Of course Microsoft recommends that you install the patch as soon as possible.

In addition to the two other side effects to installing MS11-072 (http://support.microsoft.com/kb/2553091) , as mentioned in the previous blog, there is yet another issue - this time with charts. Mind you this problem doesn't happen with all charts, but with some charts you will see the horizontal axis is no longer being plotted as separate data points. Before the update your chart may look normal:

But after the update your chart may suddenly look similar to the following:

There is a workaround for this problem, though not a permanent solution as yet. To work around the problem, right click the horizontal axis and click 'Format Axis'. In the dialog box that comes up you will want to set the 'Axis type' from 'Automatically select based on data' to 'Text Axis'. This will force the chart to render correctly.