Sign in
The Microsoft Excel Support Team Blog
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Common Tasks
Home
OK
RSS for comments
RSS for posts
Atom
Search
Tags
2596545 2597142 218153 ForceShellExecute
DCOM DCOMCNFG Microsoft Excel Application Microsoft Word Application
Excel 2007
Excel 2010
Excel 2013
Excel 2013 PowerPivot add-in
excel hang add-in outlook behind
Excel15
index match formula lookup
MS12-060 COM Automation
Office 2013
Performance
PivotTable
PowerPivot
Powerpivot Excel Services
PowerPivot for Excel 2013
PowerPivot install
sort available resources ms12-030
VB6 MS12-027 Update control mscomctl
VBA
VPN
Word 2007
Word 2010
Word 2013
XML
Monthly Archives
Archives
December 2014
(2)
October 2014
(1)
September 2014
(1)
August 2014
(1)
June 2014
(2)
May 2014
(2)
April 2014
(1)
March 2014
(3)
November 2013
(2)
October 2013
(3)
September 2013
(1)
August 2013
(1)
June 2013
(1)
May 2013
(1)
April 2013
(2)
March 2013
(2)
February 2013
(2)
January 2013
(2)
December 2012
(5)
November 2012
(5)
October 2012
(1)
September 2012
(2)
August 2012
(3)
June 2012
(4)
May 2012
(3)
April 2012
(4)
March 2012
(2)
February 2012
(1)
January 2012
(1)
December 2011
(3)
November 2011
(4)
October 2011
(5)
September 2011
(5)
June 2011
(1)
March 2011
(2)
The Microsoft Excel Support Team Blog
TechNet Blogs
»
The Microsoft Excel Support Team Blog
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Dynamics CRM files do not open in Excel 2013 as expected
Posted
8 hours ago
by
Amber Me - MSFT
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...
Form Controls stop working after December 2014 Updates
Posted
11 days ago
by
Amber Me - MSFT
76
Comments
For some users, Form Controls (FM20.dll) are no longer working as expected after installing MS14-082 Microsoft Office Security Updates for December 2014. Issues are experienced at times such as when they open files with existing VBA projects using forms...
Excel 2013 error connecting to .bism files "The handle is invalid"
Posted
2 months ago
by
Amber Me - MSFT
2
Comments
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...
HTML table cells may display incorrectly
Posted
3 months ago
by
Amber Me - MSFT
1
Comment
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...
Excel print settings do not change when switching printers
Posted
4 months ago
by
Amber Me - MSFT
1
Comment
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...
PowerPivot for Excel 2013 error when opening the Manage Window
Posted
5 months ago
by
Amber Me - MSFT
5
Comments
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...
Microsoft Office error when opening if IE temporary file location is changed or blank
Posted
6 months ago
by
Amber Me - MSFT
1
Comment
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."...
Stuff you wish Excel 2013 had – and find out that it does!
Posted
7 months ago
by
Anita [MSFT]
4
Comments
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...
Slow saving of Office files to a network server using EFS
Posted
7 months ago
by
Amber Me - MSFT
1
Comment
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...
Unable to open ISO Strict .xlsx files in Excel for iPad, Mac or iPhone
Posted
8 months ago
by
Amber Me - MSFT
3
Comments
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...
Unable to open Excel files from a SharePoint 2010 on an iPad
Posted
9 months ago
by
Laura Holzwarth-Struck [MSFT]
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...
Excel 2013 PowerPivot or Power Map add-ins are not installed with MSP from Office Customization Tool
Posted
9 months ago
by
Amber Me - MSFT
4
Comments
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...
Office 2013 reports no internet connectivity with VPN connection
Posted
9 months ago
by
Amber Me - MSFT
1
Comment
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...
PowerPivot for Excel 2013 errors after October update KB 2825655
Posted
over 1 year ago
by
Amber Me - MSFT
14
Comments
(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...
Updated! Excel 2013 crashes when you attempt to scroll down the page
Posted
over 1 year ago
by
Anita [MSFT]
33
Comments
Hello everyone We have seen several reports of Excel crashing when you scroll down, even on a brand-new sheet. The Application Event log points to a crash in OSF.dll. We have found that at least one cause of this particular crash is a conflict with...
All files stored on a drive or server share are corrupted and will not open
Posted
over 1 year ago
by
Laura Holzwarth-Struck [MSFT]
1
Comment
We are still seeing many reports globally that people are unable to open multiple Office Files (Word, Excel, PowerPoint) or other files such as JPEG or AutoCAD. This is another symptom of the Malware attack that we reported on in early September. ...
Excel 2013 Pivottable Select Multiple Items checkboxes disappear
Posted
over 1 year ago
by
Amber Me - MSFT
12
Comments
(Updated Dec 2013) It has been reported that after applying the latest updates for Excel 2013, the pivottable option to "select multiple items" and basic filtering is behaving strangely for some users. When making that selection and trying...
Excel 2013 PowerPivot or PowerView add-ins are not available
Posted
over 1 year ago
by
Amber Me - MSFT
5
Comments
We have had reports of the Microsoft Excel 2013 PowerPivot or PowerView add-ins not loading in the ribbon. When users then try to add the add-ins (File > Options > Add-ins) by browsing to the .dll’s in the COM dialog, they are not added...
Updated 9/11 - "Excel cannot open the file [filename] because the file format or file extension is not valid." opening Office files
Posted
over 1 year ago
by
Will Buffington [MSFT]
58
Comments
There is currently an ongoing situation where users may encounter an error when trying to open Office documents. The error can happen opening any Office file type, not just Excel files. For Excel file types, the error says: "Excel cannot open the file...
Absolute Structured Referencing - A Nifty Little Trick
Posted
over 1 year ago
by
Anita [MSFT]
3
Comments
Hi Everyone, One of our MVPs brought a tutorial on ExcelCampus ( http://www.excelcampus.com/tips/absolute-formula-references-excel-structured-table/) to my attention, and I thought it was so cool we should probably share it with everyone. When you...
Text and icon for embedded Office document disappears in Excel
Posted
over 1 year ago
by
Will Buffington [MSFT]
1
Comment
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...
Excel Crashes When You Enter Data in a Cell
Posted
over 1 year ago
by
Anita [MSFT]
79
Comments
We want to bring an emerging issue to your attention. We have found that in certain circumstances, Excel will crash when you type data into a cell and press < Enter >. The same crash may occur when you select data and click the Quick Analysis button...
How to Troubleshoot Memory Errors in Excel; "Available Resources", "Out of Memory", "System Resources"
Posted
over 1 year ago
by
Laura Holzwarth-Struck [MSFT]
4
Comments
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...
Office 2013 VBA component stops functioning
Posted
over 1 year ago
by
Laura Holzwarth-Struck [MSFT]
5
Comments
We are seeing a few cases where the VBA component of the Office 2013 apps stop functioning. The applications are working properly when installed. Then a few days later VBA buttons no longer work. Here are the scenarios that we have seen: Access: ...
Problem Reopening Excel 2013 PivotTable Workbooks
Posted
over 1 year ago
by
Anita [MSFT]
13
Comments
We’ve had a few reports recently from people who have built new PivotTables in Excel 2013, and when they try to reopen the book, receive a message saying: We found a problem with some content in <filename>. Do you want us to try to recover...
>