Dynamics CRM files do not open in Excel 2013 as expected

If an Excel workbook in XML Spreadsheet format (*.xml) is stored as a UTF-16 Unicode text stream, you may have problems opening it in the expected program when trying to open it through Windows Explorer or Windows Internet Explorer. This problem can occur if you have Office 2013 or an Office 2013 component installed. Example…

2

Excel 2013 error connecting to .bism files "The handle is invalid"

After applying May 2014 Cumulative updates for Office 2013 Click-to-Run, an error occurs when refreshing an existing workbook data connection to a .bism file and/or when creating a new connection using a .bism file.   The message received is:  "The following System Error occurred: The handle is invalid"       Note:  This has been found to occur only with Click-to-Run Office 2013 WORKAROUND: Connect…

2

HTML table cells may display incorrectly

    Table cells may be displayed in the wrong location when opening large HTML files in Excel 2003, Excel 2007, Excel 2010 or Excel 2013.   This can occur if there is a <td> tag that contains a <br> with a large number of rows or cells spanning multiple rows and columns. For example:     <td >Test Text<br>Test Text</td>   Workaround:…

1

Excel print settings do not change when switching printers

    Windows DevMode has a limitation of 32 characters. What this means is that printer names cannot be longer than 32 characters… 31 really.    Why does it matter? When Excel queries the printers, it is given the printer name information from Windows. Windows DevMode is limited by design and will truncate the name…

1

PowerPivot for Excel 2013 error when opening the Manage Window

We’ve had reports of an error when trying to open the PowerPivot for Excel 2013 'Manage' window after installation. This error does not happen for an Admin user.  The message received is:  "We couldn't load the Data Model. This may be because the Data Model in this workgroup is damaged"           In this circumstance, originally, the reason for this…

5

Microsoft Office error when opening if IE temporary file location is changed or blank

  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…

1

Stuff you wish Excel 2013 had – and find out that it does!

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…

4

Slow saving of Office files to a network server using EFS

      Symptoms If you use the Encrypting File System (EFS) to secure the Temporary Internet Files folder, you will experience slow saving to a server that is capable of supporting encryption but is not configured to do remote encryption. We've had reports of this causing a delay from 45-120 seconds to save a…


Unable to open ISO Strict .xlsx files in Excel for iPad, Mac or iPhone

  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…

3

Unable to open Excel files from a SharePoint 2010 on an iPad

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 openthe app.” SharePoint 2010 requires a…