PowerPivot for Excel 2013 errors after October update KB 2825655

(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…

14

Updated! Excel 2013 crashes when you attempt to scroll down the page

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 Avast! Antivirus. Essentially, if you install Avast! and then open any…

33

All files stored on a drive or server share are corrupted and will not open

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.    When attempting to open any files you may encounter one of the following messages:  For Microsoft…


Excel 2013 Pivottable Select Multiple Items checkboxes disappear

 (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 to select various items, the checkboxes are "disappearing". The build this has been reported for is:  15.0.4535.1507…


Excel 2013 PowerPivot or PowerView add-ins are not available

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 as expected. This problem can occur when using tools for migration, such as AppSense, and all personalization settings…

5

Updated 9/11 – "Excel cannot open the file [filename] because the file format or file extension is not valid." opening Office files

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 [filename] because the file format or file extension is not valid. Verify that…


Absolute Structured Referencing – A Nifty Little Trick

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 select a column of data in a table to create a reference in your formulas, it automatically creates a structured reference for you – say…

3

Text and icon for embedded Office document disappears in Excel

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…


Excel Crashes When You Enter Data in a Cell

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. We are currently investigating the issue, but it has been…

81

How to Troubleshoot Memory Errors in Excel; "Available Resources", "Out of Memory", "System Resources"

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…