Bước 1: Vào hành lang cửa số Deverloper bên trên Excel/ chất vấn trạng thái nút bấm Visual Basic hoặc Macros xem có ở trạng thái sáng màu xuất xắc không
TH1: Nút bấm làm việc trạng thái sáng sủa è setup đủ Visual Basic
TH2: Nút bấm sinh hoạt trạng mại thái mờ è thiết lập thiếu Visual Basic è sở hữu đặt bổ sung Office
2. Quá trình cài để Visual Basic (VBA) mang lại Offfice (Excel)
Bước 1: Control Panel/Programs/Programs and Features/Click chuột buộc phải trong cỗ cài Office/ Change
Bước 2: Thiết lập thiết đặt Visual Basic mang lại Office: Chọn địa chỉ cửa hàng or Remove Featues/Continue/Trong mục Office Shared Features/Visual Basic for Applications/Run from My Computer/Continue
Như vậy với công việc hướng dẫn trên chúng ta đã thiết đặt Visual Basic bị thiếu thốn trên Office, sau khi hoàn tất tùy chỉnh lập các bạn đã sở hữu thể kích hoạt lại tính năng có thể chấp nhận được chạy Macro khi mở tệp tin Excel, trường hợp bạn chưa biết cách tùy chỉnh cấu hình này:
Tham khảo ngay bài bác viết: phía dẫn tùy chỉnh cấu hình Macro Setting được cho phép chạy Macro trên tệp tin Excel đựng Macro
Liên hệ đặt hàng khóa học tập trực tiếp theo sau yêu cầu riêng của doanh nghiệp:
Email Baoninh
gmail.com
Năng lực của Bluesofts triển khai huấn luyện trực tiếp tại doanh nghiệp: HONDA, VNPT, VINGROUP, VIETTEL, BAOVIET, HONDALOCK, STYLESTONE, TÔ VIỆT PHARMA, ĐỨC KIÊN PLASTIC, CIIEC GROUP, IBM, ABB, SÔNG ĐÀ 9….
Bạn đang xem: Mở file excel 2010 báo lỗi "cannot run the macro
Đăng ký tham gia khóa đào tạo Excel nâng cấp cho bạn đi làm: TẠI ĐÂY
Đăng cam kết tham gia khóa đào tạo Kỹ thuật tạo report động trên Excel và Atools: TẠI ĐÂY
Trả lời Hủy
Email của các bạn sẽ không được hiển thị công khai. Những trường yêu cầu được ghi lại *
Bình luận
Tên *
Email *
Trang website
giữ tên của tôi, email, và website trong trình ưng chuẩn này mang lại lần comment kế tiếp của tôi.
JP, I"ll demo this today on 64-bit Excel và let you know what I find out. The only criteria for reproducing the issue is to open a spreadsheet that contains a macro?Will Buffington
Microsoft Excel Support
Correct. None of my workbooks without macros have any problem. I found a solution, for now: that is to have all macro workbooks saved in 2007 compatibility mode, then everything works well (like it did when using Excel 2007).
THANK YOU for looking into this.
Hi,
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 và deleting macros.
After that,compile your VBA code again & save it & close it.
Finally, make excel option back as "enable all macro" and uncheck at "diable all trusted document".
You can happily mở cửa your file without any crashing.
Hi,
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 check at "diable all trusted document". Then you can open your file 100% without any crashing & deleting macros.
After that,compile your VBA code again & 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ì chưng we get this khổng lồ the attention of Microsoft khổng lồ get it fixed?The very best to you, CSUN,JP
Tuesday, August 17, 2010 5:01 PM
0
Sign in lớn 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 do with the Trust Center.This is very time-consuming and frustrating.
Saturday, August 21, 2010 4:01 PM
0
Sign in to lớn 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
0
Sign in to lớn vote
Thanks khổng lồ Goose 7777!! So far this has worked for me:
Open the file in Excel 2007 (I had 3 files that wouldn"t xuất hiện in Excel 2010and they all opened in Excel 2007 - I have it on my Virtual Machine)
Added a blank module, compiled, and Saved
I could then mở cửa the spreadsheet in Excel 2010 again without crashing.
orrn1
ORRN1Friday, July 22, 2011 8:30 PM
0
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 lớn the opposite. Crashes all over. Especially when formatting cells...
Now I choose Belgium as country and language but UK as keyboard layout.
Next thing what happened: ALL MY EXCEL FILES are BACK !! NO MORE CRASHES.
Check your country và language settings and feel the joy.
Wednesday, September 28, 2011 5:33 PM
0
Sign in to lớn vote
Stephen,
FYI
Excel 2010 64 bit compared khổng lồ 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 64The 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 http://www.decisionmodels.com/Wednesday, September 28, 2011 5:57 PM
0
Sign in khổng lồ vote
Charles,
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 lớn be able to use Powerpivot but based on your valuable input, I may be able to lớn re-engineer to 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 support 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 khổng lồ me that the 64 bit hàng hóa offering was based on getting increased sales and not on delighting the customer.
Steve
Tuesday, October 4, 2011 10:28 AM
0
Sign in khổng lồ vote
Gentlemen,
I have a temporary fix until microsoft resolves this:
Private Sub Workbook_Open()For Each sht In Worksheets
Set my
Document = sht
For Each sh In my
Document.Shapes sh.Delete
Next
Next
End Sub
There appears lớn be a known problem with 64 bit 2010 Excel writing out certain objects. The above code, assuming you can open the file, will remove all objects like text boxes, comments, shapes, etc that you may be able lớn live without temporarily. Removing these objects will allow you to lớn save your work.
Having read this forum, I decided to 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 lớn reconstruct the file.
Sub Reconstruct
Workbook()Dim F As String
Dim Shts As Integer
On Error Resume Next Application.Display
Alerts = False Dim Wkb As Workbook Dim Send
Wkb As Workbook Ch
Dir "C:Test" Workbooks.Add mix Wkb = Active
Workbook Wkb.Calculation = xl
Calculation
Manual For t = 1 khổng lồ 9 mix Send
Wkb = Workbooks.Open(Filename:="C:Test ab" & t và ".xlsx", Update
Links:=1) Send
Wkb.Application.Calculation = xl
Calculation
Manual Sheets(1).Select Shts = Wkb.Sheets.Count Application.Cut
Copy
Mode = False Sheets(1).Copy After:=Wkb.Sheets(Shts) Send
Wkb.Activate Active
Window.Close If t = 1 Then Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select Active
Window.Selected
Sheets.Delete over If Wkb.Activate On Error Go
To dns Wkb.Save
As Filename:="C:TestRe
Created
Picasso33z.xlsx", File
Format:=52 Next t
Application.Display
Alerts = True
Application.Status
Bar = "Ready"End Sub
This is a lot of extra work but perhaps this will help everyone 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 xuất hiện 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 power users in the Excel arena.
Stephen Druley, CEO
Trends-to-Know LLC
Friday, October 7, 2011 11:24 AM
0
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 to 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 lớn disabling macros) has a 10% chance of contributing lớn the Microsoft Excel 64 bit problem explaned in the header of this thread. The purpose of the chart is to xuất hiện up other solutions or change our thinking patterns khổng lồ consider other options at solving the problem.
Stephen Druley
Monday, June 11, 2012 12:49 PM
0
Sign in lớn 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 & generates a report. I have been using this program with different versions of OS, and different versions of Office with no issues. Now on a
Windows7 64 bit version và Office 2010 64-bit version, I get “Excel stopped working..” message. The VB program seems to lớn be working finein the 32 bit environment but Excel has issues. If I mix a break point right at the beginning of excel & step through it I get the report I want, but if I just let excel do it it crashes.
I have tried putting wait statements in different parts of the vba code, và that seems to remedy the issue sometimes, depending on the form size of the data or something, but its not predictable!!
At the beginning Iremoved all the API calls, & the timer (the timer control is not supported for 64-bit), shorten the amount of work that the vba has lớn 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 luck..is there a solution to lớn this??
The reason I have lớn 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 to manipulate data on the fly.
I don’t know how khổng lồ 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: Máy Nước Nóng Năng Lượng Mặt Trời Ariston, Đại Lý Giàn Bình
I have gone through disabling macros, và trusted locations, but that doesn"t seem to help either.