JP, I"ll test this today on 64-bit Excel and let you know what I find out. The only criteria for reproducing the issue is to open a spreadsheet that contains a macro?Will BuffingtonMicrosoft Excel Support

Correct. None of my workbooks without macros have any problem. I found a solution, for now: that is to lớn have all macro workbooks saved in 2007 compatibility mode, then everything works well (like it did when using Excel 2007).

Bạn đang xem: Pab enhancement: outlook report message add

THANK YOU for looking into this.




This problem is caused by Macro security.

I recommend you to mở cửa your crashed tệp tin as "diable all macro" and kiểm tra at "diable all trusted document". Then you can xuất hiện your tệp tin 100% without any crashing và deleting macros.

After that,compile your VBA code again và save it & close it.

Finally, make excel option back as "enable all macro" & uncheck at "diable all trusted document".

You can happily xuất hiện your tệp tin without any crashing.




This problem is caused by Macro security.

I recommend you to xuất hiện your crashed tệp tin as "diable all macro" and kiểm tra at "diable all trusted document". Then you can open your file 100% without any crashing and deleting macros.

After that,compile your VBA code again và save it và close it.

Finally, make excel option back as "enable all macro" và uncheck at "diable all trusted document".

You can happily mở cửa your file without any crashing.

Wow, that seems to work consistently! It"s a workaround but at least I won"t be losing any more files.Many many thanks, CSUN, for sharing this.Now how vì we get this lớn the attention of Microsoft to lớn get it fixed?The very best khổng lồ you, CSUN,JP
Tuesday, August 17, 2010 5:01 PM

Sign in to vote
Well, I spoke too soon; shortly after I posted the above 64-bit Excel was crashing again. I suspect it does have something to vì chưng with the Trust Center.This is very time-consuming and frustrating.
Saturday, August 21, 2010 4:01 PM
Sign in to vote

I think I found the solution. It has worked on 3 computers I have tried it on so far.

Very simple. Empty the c:windows emp directory.

Mike K.

Friday, September 17, 2010 9:06 PM
Sign in lớn vote

Thanks lớn Goose 7777!! So far this has worked for me:

Open the tệp tin in Excel 2007 (I had 3 files that wouldn"t mở cửa in Excel 2010and they all opened in Excel 2007 - I have it on my Virtual Machine)

Added a blank module, compiled, và Saved

I could then xuất hiện the spreadsheet in Excel 2010 again without crashing.


Friday, July 22, 2011 8:30 PM
Sign in to vote

You can solve this problem by checking your Language setting/Country settings in Windows 7.

This is what is causing the crashes !!

I like to work with "komma," as decimal seperator but my Country và Language was set to English (UK) which uses the opposite...therefor I customised the comma and full stop to lớn the opposite. Crashes all over. Especially when formatting cells...

Now I choose Belgium as country and language but UK as keyboard layout.

Xem thêm: Đăng Xuất Tài Khoản Youtube Từ Xa, Đăng Xuất Hoặc Xóa Tài Khoản Khỏi Youtube Trên Tv

Next thing what happened: ALL MY EXCEL FILES are BACK !! NO MORE CRASHES.

Check your country & language settings and feel the joy.

Wednesday, September 28, 2011 5:33 PM
Sign in lớn vote



Excel 2010 64 bit compared lớn Excel 2010 32 bit:-

Excel 2010 64 is not any faster than Excel 2010 32 The multithreading capabilities are the same The multi-Instance capablilities are the same Inter instance capabilities are the same AFAIK either Excel 32 or Excel 64 can be installed under Win 7 64

The only significant difference (apart from handling 64-bit Windows API calls) is that each instance of Excel 2010 64 bit can address much larger memory than the 2 GB per instance limit of Excel 2010 32.

Charles Excel MVP The Excel Calculation Site
Wednesday, September 28, 2011 5:57 PM
Sign in to vote


You are correct here. I was confused about what I was comparing. I guess my assumption that more data could be moved more quickly with a higher bit count meant higher throughput. I guess I was incorrect on this.

I use 64 bit to lớn be able lớn use Powerpivot but based on your valuable input, I may be able khổng lồ re-engineer to lớn 32 bit. Bởi you think this will resolve my "Microsoft Stopped Working" error. Also, my application uses about 15% of 25G of memory on my machine.

I currently have an open tư vấn case with Microsoft on the "Microsoft Stopped Working" error but, so far, they are dragging their feet on the reply.

I wrote a fix-it program to lớn save each tab on my workbooks as a way of recreating the affected files. Now the fix-it program won"t open.

Notwithstanding these difficulties, it would appear to me that the 64 bit sản phẩm offering was based on getting increased sales and not on delighting the customer.


Tuesday, October 4, 2011 10:28 AM
Sign in lớn vote
I have a temporary fix until microsoft resolves this:

Private Sub Workbook_Open()For Each sht In WorksheetsSet myDocument = shtFor Each sh In myDocument.Shapes sh.DeleteNextNextEnd SubThere appears to lớn be a known problem with 64 bit 2010 Excel writing out certain objects. The above code, assuming you can xuất hiện the file, will remove all objects lượt thích text boxes, comments, shapes, etc that you may be able to live without temporarily. Removing these objects will allow you lớn save your work.
Having read this forum, I decided to lớn save each of the worksheets of my workbook separately so I could reassemble them in case this problem reared its ugly head. Well, it did. So now I use the code below khổng lồ reconstruct the file.
Sub ReconstructWorkbook()Dim F As StringDim Shts As IntegerOn Error Resume Next Application.DisplayAlerts = False Dim Wkb As Workbook Dim SendWkb As Workbook ChDir "C:Test" Workbooks.Add mix Wkb = ActiveWorkbook Wkb.Calculation = xlCalculationManual For t = 1 to lớn 9 set SendWkb = Workbooks.Open(Filename:="C:Test ab" và t & ".xlsx", UpdateLinks:=1) SendWkb.Application.Calculation = xlCalculationManual Sheets(1).Select Shts = Wkb.Sheets.Count Application.CutCopyMode = False Sheets(1).Copy After:=Wkb.Sheets(Shts) SendWkb.Activate ActiveWindow.Close If t = 1 Then Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select ActiveWindow.SelectedSheets.Delete end If Wkb.Activate On Error GoTo dns Wkb.SaveAs Filename:="C:TestReCreatedPicasso33z.xlsx", FileFormat:=52 Next tApplication.DisplayAlerts = TrueApplication.StatusBar = "Ready"End Sub
This is a lot of extra work but perhaps this will help everyone to lớn be productive again until these issues are fixed. I am currently working with Microsoft on a paid case with the objective of getting my file to open and save correctly & to sort out those shapes in the shape collection that are problematic for the 64 bit Excel 2010.
I hope this offers some help lớn the thousands of people worldwide who are nguồn users in the Excel arena.
Stephen Druley, CEO
Trends-to-Know LLC
Friday, October 7, 2011 11:24 AM
Sign in to vote


Hopefully some of the microsoft Engineers will take this chart & include it in their thinking. The approach is new and hopfully it may contribute lớn the complex issue we are facing. The chart contains overlapping probabilities. An example on how lớn read is: Disabling all macros (or engaging in an activity that has causal ties to disabling macros) has a 10% chance of contributing to the Microsoft Excel 64 bit problem explaned in the header of this thread. The purpose of the chart is to open up other solutions or change our thinking patterns to consider other options at solving the problem.

Stephen Druley

Monday, June 11, 2012 12:49 PM
Sign in to vote

I have a 32 bit VB6 application that starts an Excel workbook, programatically. Once the workbook starts it opens few data text files, generated by the VB program, reads the data in, runs calculations on the data và generates a report. I have been using this program with different versions of OS, và different versions of Office with no issues. Now on aWindows7 64 bit version & Office 2010 64-bit version, I get “Excel stopped working..” message. The VB program seems khổng lồ be working finein the 32 bit environment but Excel has issues. If I mix a break point right at the beginning of excel và step through it I get the report I want, but if I just let excel vì chưng it it crashes.

I have tried putting wait statements in different parts of the vba code, and that seems lớn remedy the issue sometimes, depending on the kích cỡ of the data or something, but its not predictable!!

At the beginning Iremoved all the API calls, và the timer (the timer control is not supported for 64-bit), shorten the amount of work that the vba has to do, but there is no one place that causes the problem thats visible.

I have spent a lot of time on internet searching for an answer with no there a solution to lớn this??

The reason I have to fix this, is incase our users have Excel 64-bit installed on their system..

The Excel version on my 64bit machine is Professional Plus 2010 14.0.6106.5005 (64-bit)

I need the macro’s because they need lớn manipulate data on the fly.

I don’t know how to lớn start the workbook in safe mode, since it is started from a VB program!

I don’t have any shapes, or formulas within the cells.Everything is done through macros. I did change the API calls to tư vấn 64 bit Excel, but that does not seem to be the issue.

Xem thêm: Tại Sao Không Bình Luận Được Trên Facebook, Access Denied

I have gone through disabling macros, and trusted locations, but that doesn"t seem to lớn help either.