Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Monday, February 27, 2017 9:41 PM
We recently upgraded to windows 10, both Office 2016 and O365 users are reporting Excel locking up when they have multiple (3 or more) spreadsheets open. These same spreadsheets were just fine in Windows 7 with Office 2016.
It is wide spread.
Everyone with windows 10 is experiencing Excel Crashing. I have tried disable addons - no luck. I've tried safe mode - no luck. I've tried disabling Live Previews in the Options > General tab - no luck. I've tried disabling the Hardware graphics acceleration in Options > Advanced - no luck. I've tries re-installing Office 2016 - no luck. I've tried rebuilding the computer with a brand new image from scratch! - no luck. Excel keeps crashing. Windows 10 Aniversary eddition... when using Office 2016 or O365... Excel Crashes multiple times daily for all users.
I'm wondering when Microsoft is going to fix this know issue which seems to be WIDESPREAD across the blogosphere. Stop asking us questions Microsoft, about whether or not we have Word open Microsoft, or where our excel spreadsheets are located, Microsoft! They are located everywhere! And you have not provided a solution. All you do is ask more pointless questions and fail to provide a solution. Stall tactics?
</End Rant>
Seriously Microsoft! I've been through dozens of Microsoft forums all over the internet and ALL OVER TECHNET! and ALL HAVE BEEN OF NO HELP WHATSOEVER.
Microsoft? Why have you released a faulty product Microsoft? And when are you going to patch Excel 2016 and Excel in O365 for Windows 10?
Gracefully your,
All replies (18)
Tuesday, February 28, 2017 7:27 AM
Hi HDatMWay,
Sorry for any convenience this has caused. We can fully understand your frustration.
Problems with Excel crashing or hanging can be caused by various things. As it seems that the crash problem affects all users on Windows 10 in your environment, are these users working with the shared files on a same network? What if working while away from the network?
Besides, to help troubleshoot the problem, could you please collect some related error logs via Event Viewer when the issue occurs then we can do further research on this?
Please feel free to post back with any findings and we are glad to help you.
Best regards,
Yuki Sun
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact [email protected].
Tuesday, February 28, 2017 2:01 PM
Hello Yuki Sun, Thank you for responding.
The Excel files which are crashing are located on various shared drives and/or on SharePoint. The users do not manage these Excel files from outside the network. This particular user is on Windows 10 anniversary edition with Office 365. Below is the error log event:
Error: Application Hang - Event ID: 1002 - Task Category: (101)
General
The program EXCEL.EXE version 16.0.4480.1000 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel.
Process ID: 3a84
Start Time: 01d28d2b28268638
Termination Time: 36
Application Path: C:\Program Files\Microsoft Office\Office16\EXCEL.EXE
Report Id: aa7aea9c-f920-11e6-a2f5-9cebe8414316
Faulting package full name:
Faulting package-relative application ID:
NOTE - These same users (using the very same spreadsheets) had no issues before switching to Windows 10. The same Spreadsheets, in the same location, with the same users had no issues when we were using Office 2016 on Windows 7. The same Spreadsheets, in the same location, with the same users only started crashing when we went to Windows 10.
Monday, March 6, 2017 5:17 PM
No response... Got it.
Thursday, March 9, 2017 3:18 PM | 1 vote
Solved?
It would appear Spiceworks has the answers...
To FIX THIS ISSUE do the following:
Open excel,
go to File > Options > General > User Interface options - Deselect the "Live Preview" option.
Then go to File > Advanced > Display - and Select the "Disable hardware graphics acceleration" option.
Long Live Spiceworks!
Friday, March 10, 2017 2:22 PM
Not-Solved...
Turns out the fix above only "fixed" it for about half of the end users.
Friday, March 10, 2017 3:12 PM
Hi HelpDesk Hero Squad,
Sorry fot the delay.
>> only "fixed" it for about half of the end users.
Are these users all running Office 365 or using the same build of Office?
Have you tried checking for and installing all the available updates for both Windows 10 and Office to see if there will be any improvement?
It is also suggested to try performing a clean boot in Windows to check the result.
Best regards,
Yuki Sun
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact [email protected].
Friday, March 10, 2017 5:57 PM | 1 vote
This is not just an Excel 2016 issue. I have seen the same issue when opening multiple PDFs using Adobe Acrobat Reader (multiple versions). This appears to be a resource restriction inside the OS itself.
Tuesday, May 23, 2017 1:51 PM
I think you may be right, Mr Ober. So what are we supposed to tell our users, Wait for Windows 11 for Microsoft to fix their OS?
Thursday, June 1, 2017 4:49 AM
Feel your pain, am in exactly the same position. I have users on a witch-hunt coming out with pitchforks at the IT dept for a resolution
Question, did you try any of the fixes supplied in https://support.microsoft.com/en-us/help/2758592/how-to-troubleshoot-crashing-and-not-responding-issues-with-excel
make any difference?
Thanks,
LAD
LD
Thursday, June 1, 2017 12:09 PM
It appears that one of the April 2017 resolved this. Since those patches were applied the problem has disappeared for my users. I have Windows 10 v1511, v1607, and v1703 and it's gone from all three releases.
Friday, June 2, 2017 5:23 AM
Mike that is very encouraging to hear. I am immediately going to release the latest version to my users.
LD
Friday, June 9, 2017 2:43 AM
FYI we are also educating our users with elements from the KB2735548
Primarily on
- Cleaning up Excel Conditional Formatting (Which can be easily done with the Inquire Addin)
- Bad practice formulas. See Method 2
Formulas that reference entire columns may trigger poor performance in .xlsx files. Such formulas grow the grid size from 65,536 to 1,048,576 rows and 256 (IV) to 16,384 (XFD) columns. A popular way to create formulas (although not a best practice) is to reference entire columns. If you reference just one column, this implicates only 65,536 cells. With the new grid, more than one million cells are involved.
LD
Thursday, July 13, 2017 12:38 PM
My story so far
- Updated Office 2016 to the MAY 2017 release
- Printer drivers were updated on all PCs
- Turned off 'Let Windows manage my default printer'
- Display drivers updated on all PCs with the PC vendor driver (for eg HP site driver used, not Intel)
- Windows 10 updated to the latest
The above seems to have fixed @ 50% of our users
For the rest we're going to try a combination of
- Enabling Office Telemetry (Offcat is not helpful in the least)
- Educating users on good practice formulas
- Logging a ticket with Microsoft (We have premier support)
LD
Friday, September 1, 2017 1:47 PM
My story so far
- Updated Office 2016 to the MAY 2017 release
- Printer drivers were updated on all PCs
- Turned off 'Let Windows manage my default printer'
- Display drivers updated on all PCs with the PC vendor driver (for eg HP site driver used, not Intel)
- Windows 10 updated to the latest
The above seems to have fixed @ 50% of our users
For the rest we're going to try a combination of
- Enabling Office Telemetry (Offcat is not helpful in the least)
- Educating users on good practice formulas
- Logging a ticket with Microsoft (We have premier support)
LD
Is the problem resolved for you? If not then don't mark this as resolved. For me the problem resolved itself with the April 2017 updates, not only for Excel but also for Adobe Reader DC, but apparently those updates didn't resolve it for everybody.
Monday, February 5, 2018 10:49 PM
No means to revive a dead thread, but I was curious if anyone:
Discovered any other fixes to this issue that may not have been listed?
Could point me in the direction if there is a better resource they're aware of?
We've been encountering this issue for months in a small business office and it's grown from a thorn to a festering wound as the count gets higher revisiting the same users to try yet another solution. It's really inconvenient and in some cases inhibiting people from getting things done.
Multiple users have having the same exact issue described here as well as showing the same symptom of skyrocketing CPU consumption while it's happening. For a while it was suspected that this had something to do with Excel having issues accessing the clipboard. We have one of our two Mac users having similar issues all of a sudden, but have not determined if it's the same act issue. (Potentially the poorly formatted formulas mentioned earlier.)
We've tried about 3/4 of the solutions that were discussed here, but I thought I would ask for others to give time while I try the other solutions.
I'd appreciate literally any possible resolution as we're out of ideas, but can't ignore it since finding an alternative isn't a realistic idea.
Monday, April 30, 2018 5:12 PM
I am in the same boat as EtchASketchy.
My users are using Office 365 on server 2016 and this is happening in Excel.
The program EXCEL.EXE version 16.0.9126.2152 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel.
Process ID: 3908
Start Time: 01d3de40bb098354
Termination Time: 0
Application Path: C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE
Report Id: 5b9d296d-4b9f-11e8-9674-000c29fe0004
Faulting package full name:
Faulting package-relative application ID:
Please help with some type of resolution.
Wednesday, July 25, 2018 9:00 PM
This is not true. Excel sheets are only as big as the "usedrange". If you reference a whole column in a formula, you are actually referencing only the intersect of that column and the used range. If what you said was true, Excel would become completely unusable with references to entire columns, and I can assure you it does not. Try extending the used range to 1m rows and see for yourself. It's easy to do. Just place a hard value in the last cell of column A.
Correct/useful advice would be to check the used range of all your worksheets to make sure they're not over-sized. That is a real issue and you can easily find code online to trim used ranges.
So much bad advice in these threads. Install updates - duh. Thanks guys, big help. And incorrect advice on top of that. Thanks again on behalf of everyone who's time was wasted changing all their worksheet formulas for no reason.
Wednesday, December 25, 2019 6:56 AM
Dear All,
Appears the problem has not been resolved. I upgraded from Windows 8 to Windows 10 Home in August this year. 64 bit Version 1903 OS Build 18362.535. I'm running this on a stand alone PC. The version of Excel I am running is 2010 (14.0.7243.5000) with SP2 MSO (14.0.7237.5000).
The good news is that I can re-create one of the bugs that causes Excel to crash (there are several). The bad news is I have not found a solution.
This one occurs when I step through the VBA code below. I've highlighted the offending line of code. It's when I ask Excel to save the spreadsheet to the hard drive!
I've been using Excel since it was only available for the Macintosh (1989). Excel over the decades has been one of the most stable programs around. I have to say that I'm amazed that Excel now crashes when doing something as fundamental as saving a spreadsheet?
Here's the copy of the Event Log showing the Excel crash.
Log Name: Application
Source: Application Error
Date: 25/12/2019 1:29:10 AM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: N/A
Description:
Faulting application name: EXCEL.EXE, version: 14.0.7243.5000, time stamp: 0x5de5388b
Faulting module name: VBE7.DLL, version: 7.0.16.43, time stamp: 0x58cb266e
Exception code: 0xc0000005
Fault offset: 0x000000000028d1df
Faulting process id: 0x16b8
Faulting application start time: 0x01d5badfec075f9b
Faulting application path: C:\Program Files\Microsoft Office\Office14\EXCEL.EXE
Faulting module path: C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL
Report Id: b712f6f2-c922-4c44-8242-70f4b7d7bd72
Faulting package full name:
Faulting package-relative application ID:
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2019-12-25T06:29:10.286634300Z" />
<EventRecordID>10640</EventRecordID>
<Channel>Application</Channel>
<Computer>DESKTOP-LIBIP8T</Computer>
<Security />
</System>
<EventData>
<Data>EXCEL.EXE</Data>
<Data>14.0.7243.5000</Data>
<Data>5de5388b</Data>
<Data>VBE7.DLL</Data>
<Data>7.0.16.43</Data>
<Data>58cb266e</Data>
<Data>c0000005</Data>
<Data>000000000028d1df</Data>
<Data>16b8</Data>
<Data>01d5badfec075f9b</Data>
<Data>C:\Program Files\Microsoft Office\Office14\EXCEL.EXE</Data>
<Data>C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL</Data>
<Data>b712f6f2-c922-4c44-8242-70f4b7d7bd72</Data>
<Data>
</Data>
<Data>
</Data>
</EventData>
</Event>
The following is the VBA code that causes Excel to crash.
Option Explicit
Sub Process_Data()
' import data from csv file
' Keyboard Shortcut: Ctrl+i
'
Dim asPeriods() As String ' set up Period strings in an array ("M15", "M30", ... etc)
Call Set_Up_Periods(asPeriods)
Dim avSymbols() As Variant ' set up Symbol strings in an array ("AUD", "CAD", ... etc)
Call Set_Up_Symbols(avSymbols)
Call Obtain_Equity_Curve_Data(asPeriods(), avSymbols())
End Sub
Sub Clear_Old_Data()
'// clear contents of current data
' Range("Raw_Data").Select
Workbooks("Trade System Equity Curves.xlsm").Activate
Worksheets("Data").Select ' check this code??
Range("A2:BU2").Activate
If Range("A2").Value <> "" Then ' if data exists delete data
Range(Selection, Selection.End(xlDown)).Select
Selection.Clear
End If
Range("A2").Select
End Sub
Sub Set_Up_Periods(ByRef asPeriods() As String)
'// set up Period codes in an array
Dim sPeriod As String
sPeriod = "M15 M30 H1 H4 D1" ' sPeriod = "M1 M5 M15 M30 H1 H4 D1 W1"
asPeriods() = Split(sPeriod)
''// debug code
'Dim i As Integer
'For i = 0 To UBound(asPeriods)
' Debug.Print asPeriods(i) 'Display result in Immediate window
'Next i
End Sub
Sub Set_Up_Symbols(ByRef avSymbols As Variant)
'// set up Currency Symbols codes in an array
Dim Rng As Range
Set Rng = Workbooks("Trade System Equity Curves.xlsm").Sheets("Tables").Range("Ccys")
avSymbols = Rng
''// debug code
'Dim i As Integer
'For i = 1 To UBound(avSymbols)
' Debug.Print avSymbols(i, 1) 'Display result in Immediate window
'Next i
End Sub
Sub Obtain_Symbols_List_from_File()
' open csv file containing list of symbols and assign to an array
Dim sSymbolFolder As String
Dim sSymbolFile As String
Dim sSymbolPath As String
Dim sSymbolData As String
Dim asSymbols() As String
sSymbolFolder = "E:\Users\cam_j\Desktop\Documents\Trading\Forex\
sSymbolFile = "Symbols_.csv"
sSymbolPath = sSymbolFolder & sSymbolFile
Open sSymbolPath For Binary As #1
sSymbolData = Space$(LOF(1))
Get #1, , sSymbolData
Close #1
asSymbols() = Split(sSymbolData, vbCrLf)
End Sub
Sub Obtain_Equity_Curve_Data(ByRef asPeriods As Variant, ByRef avSymbols As Variant)
' array containing time Periods array containing currencies symbols
'//
' open each data csv file and copy in data then redraw graph
'//
Dim iAnswer As Integer ' variable to receive answer from Message Box
Dim nRowNo As Long ' variable to store number of rows of data copied over from csv file
Dim sDataFolder As String ' variable to store string of data folder
Dim sDataFile As String ' variable to store name of csv file
Dim sDataFileSufx As String ' variable to store file suffix
Dim sDataPath As String ' variable to store complete ile name and folder path
Dim sSymbol As String ' variable to store currency symbol code currently being analysed
Dim sPeriod As String ' variable to store time period of currency data being analysed
Dim sReportFile As String ' variable to store name of report file
sDataFolder = "E:\Reports"
Dim i As Integer: i = 1
Dim j As Integer: j = 0 ' counters
While i < UBound(avSymbols)
sSymbol = avSymbols(i, 1)
While j < UBound(asPeriods)
Call Clear_Old_Data ' delete previous data from Data tab in spreadsheet
sPeriod = asPeriods(j)
sDataFileSufx = " SSI_Trade_13_Eqty_Crv.csv"
sDataFile = sSymbol + " " + sPeriod + sDataFileSufx
sDataPath = sDataFolder + "\ + sDataFile
ChDir sDataFolder
On Error GoTo -1
On Error GoTo NextFile
Workbooks.Open sDataPath
Range("A2:BU2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("A2").Select
Windows("Trade System Equity Curves.xlsm").Activate
Sheets("Data").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Range("A2").Select
Selection.End(xlDown).Select
nRowNo = Selection.Row()
ActiveWorkbook.Names("Data").RefersToR1C1 = "=Data!R1C4:R" + CStr(nRowNo) + "C8"
Windows(sDataFile).Activate
ActiveWindow.WindowState = xlNormal
ActiveWorkbook.Close
Sheets("Graph").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Values = "=Data!$F$2:$F$" + CStr(nRowNo)
ActiveChart.SeriesCollection(2).Values = "=Data!$G$2:$G$" + CStr(nRowNo)
' ActiveChart.SeriesCollection(2).XValues = "=Data!$D$2:$D$" + CStr(nRowNo)
ActiveChart.ChartTitle.Text = sSymbol + " " + sPeriod + " SSI v13 Open and Closed Equity"
Range("A1").Select
sDataFileSufx = " SSI_Trade_13_Eqty_Crv.xlsm"
sDataFile = sSymbol + " " + sPeriod + sDataFileSufx
sDataPath = sDataFolder + "\ + sDataFile
ChDir sDataFolder
' Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=sDataPath, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
sDataFile = "Trade System Equity Curves.xlsm"
sDataPath = sDataFolder + "\ + sDataFile
ChDir sDataFolder
'// the following line of code causes Excel to crash!!!!
ActiveWorkbook.SaveAs Filename:=sDataPath, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
' Application.DisplayAlerts = True
iAnswer = MsgBox("Do you want to continue processing data files?", vbQuestion + vbYesNo + vbDefaultButton2, "Continue Macro?")
If iAnswer = vbYes Then
GoTo NextFile
Else
GoTo Break
End If
' '// remove zero's and MT4 NULL values
' Range("I5:P5").Select
' Range(Selection, Selection.End(xlDown)).Select
' Selection.Replace What:="0", Replacement:="", LookAt:=xlPart, _
' SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
' ReplaceFormat:=False
' Selection.Replace What:="2147483647", Replacement:="", LookAt:=xlPart, _
' SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
' ReplaceFormat:=False
' format data in other spreadsheet
'// print reports
' sReportFile = sSymbol + " " + sPeriod + " FX2020 Strategy 01 ver 0.1 Page 1.pdf"
' Sheets("Chart-all data").Select
' ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=sDataFolder + sReportFile _
' , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
' :=False, OpenAfterPublish:=False
'
' sReportFile = sSymbol + " " + sPeriod + " FX2020 Strategy 01 ver 0.1 Page 2.pdf"
' Sheets("Trades P&L").Select
' ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=sDataFolder + sReportFile _
' , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
' :=False, OpenAfterPublish:=False
'// collect summary data
'// save files
NextFile:
j = j + 1
Wend
i = i + 1
j = 0
Wend
Break:
End Sub
Thanks Cam