ErrorNotes

📊 Microsoft Excel Errors

57 error notes

🐧 Linux🪟 Windows🍎 macOS🐳 Docker☸️ Kubernetes⚡ Nginx☁️ AWS🏗️ Terraform🔧 Ansible🌐 Networking🔒 SSL/TLS🐍 Python☕ Java🔷 Go🦀 Rust🐘 PHP🔵 TypeScript💚 Node.js⚛️ React🗄️ MySQL🐘 PostgreSQL🍃 MongoDB🔴 Redis📦 Git💻 VS Code📊 Microsoft Excel📗 Google Sheets📱 Android📝 WordPress🧠 AI Tools
excelintermediate

Khắc phục lỗi VBA Run-time Error 5: Invalid Procedure Call or Argument

Run-time error '5': Invalid procedure call or argument
vbaexcelruntime-errordebugging
excelbeginner

Khắc phục lỗi Run-time error '424': Object required trong Excel VBA

Run-time error '424': Object required
vbaexcel-macrosdebuggingruntime-error-424
excelintermediate

Dừng vòng lặp lỗi 'Name Already Exists' khi sao chép trang tính Excel

The name 'PrintArea' already exists. Click Yes to use that version of the name, or click No to rename the version of the 'PrintArea' you're moving or copying.
excelvbakhắc-phục-lỗivùng-đặt-tên
excelintermediate

Sửa lỗi VBA 'Must be Updated for Use on 64-bit Systems'

Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then
vbaexcel64-bitloi-bien-dich
excelbeginner

Sửa lỗi VBA Run-time Error 76: 'Path Not Found' trong Excel

Run-time error '76': Path not found
vbaexceltự-động-hóakhắc-phục-lỗi
excelbeginner

Sửa lỗi Excel 'Cannot Paste' Do Kích Thước Ô Ghép Không Khớp

Excel cannot paste the information because the cut or copied area contains merged cells, and the paste area is not the same size
excelô-ghépsao-chép-dánclipboard
excelintermediate

Sửa lỗi 'Compile error: Method or data member not found' trong VBA Excel

Compile error: Method or data member not found
vbaexcelcompile-errorobject
excelbeginner

Sửa lỗi 'Cannot group that selection' trong PivotTable Excel (Ngày tháng & Số)

Cannot group that selection
excelpivottablenhómngày tháng
excelintermediate

Cách khắc phục lỗi 'DataFormat.Error: We couldn't parse the input provided as a Date value' trong Power Query

DataFormat.Error: We couldn't parse the input provided as a Date value.
power-querymeo-excellam-sach-du-lieupower-bi
excelintermediate

Cách khắc phục lỗi #CONNECT! trong các Loại dữ liệu liên kết của Excel 365

#CONNECT!
loai-du-lieu-lien-ketexcel-365du-lieu-chung-khoankhac-phuc-loi
excelbeginner

Cách khắc phục lỗi Excel 'Data source reference is not valid'

Data source reference is not valid.
excelpivot-tablekhac-phuc-loiphan-tich-du-lieu
excelintermediate

Sửa lỗi Run-time error '28': Out of stack space trong Excel VBA

Run-time error '28': Out of stack space
excel-vbaloi-vbago-loitran-ngan-xep
excelintermediate

Fix lỗi "Microsoft Excel is waiting for another application to complete an OLE action" khi dùng External Links

Microsoft Excel is waiting for another application to complete an OLE action.
excel-olecom-interopautomation
exceltrung bình

Khắc phục lỗi 'Sharing Violation' trong Excel: 5 cách để lưu công việc của bạn

Your changes could not be saved to 'File.xlsx' because of a sharing violation. Try saving to a different file.
vi-pham-chia-sesua-loi-excelkhoa-tepxu-ly-su-co-it
excelintermediate

Sửa lỗi: 'The information cannot be pasted because the copy area and the paste area are not the same size' trong Excel

The information cannot be pasted because the copy area and the paste area are not the same size and shape
excelsao-chep-dano-bi-gopkhac-phuc-loi
excelintermediate

Cách khắc phục lỗi Excel VBA 'Can't Find Project or Library'

Compile error: Can't find project or library
vbaexceltham-chieucompile-error
excelintermediate

Sửa lỗi 'There was a problem sending the command to the program' Khi Mở Excel từ Windows Explorer

There was a problem sending the command to the program.
ddeexcel-startupwindows-explorerregistry
excelintermediate

Sửa lỗi 'Expression.Error: Access to the resource is forbidden' trong Power Query Excel (403)

DataSource.Error: Web.Contents failed to get contents from '...' (403): Forbidden. Expression.Error: Access to the resource is forbidden
power-queryexcel403-forbiddenweb-api
excelintermediate

Sửa lỗi 'This action won't work on multiple selections' trong Excel khi chọn vùng không liên tục

This action won't work on multiple selections.
excelselectionnon-contiguousmerge
excelintermediate

Sửa lỗi 'Automation error: The object invoked has disconnected from its clients' trong VBA Excel

Run-time error '-2147417848 (80010108)': Automation error The object invoked has disconnected from its clients
vbaautomationexcel-errorruntime-error
excelintermediate

Sửa lỗi 'Run-time error 6: Overflow' trong VBA Excel khi biến vượt giới hạn kiểu dữ liệu

Run-time error '6': Overflow
excelvbaoverflowkiểu-dữ-liệu
excelintermediate

Sửa lỗi 'This workbook contains one or more links that cannot be updated' trong Excel

This workbook contains one or more links that cannot be updated.
excelliên-kết-ngoàiliên-kết-bị-hỏngkết-nối-dữ-liệu
excelintermediate

Sửa lỗi Run-time error '429': ActiveX component can't create object trong Excel VBA

Run-time error '429': ActiveX component can't create object
vbaactivexcomlỗi runtime
excelintermediate

Sửa lỗi Excel: 'filename.xlsx' bị khóa để chỉnh sửa trên ổ đĩa mạng

'filename.xlsx' is locked for editing by 'username'. Click 'Notify' to open a read-only copy of the document and receive notification when the document is no longer in use.
o-dia-dung-chungsua-loi-excelkhoa-teploi-smb
excelintermediate

Cách sửa lỗi 'Run-time error 91: Object variable or With block variable not set' trong Excel VBA

Run-time error '91': Object variable or With block variable not set
vbaexcelbiến-đối-tượngmacro
excelintermediate

Sửa lỗi Excel 'We found a problem with some content' bằng cách tái cấu trúc XML thủ công

We found a problem with some content in 'filename.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.
xlsxxmlhỏngsửa lỗi
excelbeginner

Sửa lỗi 'Cannot empty the Clipboard' trong Excel khi Copy-Paste

Cannot empty the Clipboard. Another program might be using the Clipboard.
excelclipboardcopy-pastewindows
excelintermediate

Sửa lỗi 'Expression.Error: The key didn't match any rows in the table' trong Power Query Excel

Expression.Error: The key didn't match any rows in the table.
power-queryexcelexpression-errormerge
excelintermediate

Sửa lỗi VBA 'Run-time error 13: Type Mismatch' trong Excel — Giải thích xung đột kiểu dữ liệu

Run-time error '13': Type Mismatch
excelvbamacrotype-mismatch
excelintermediate

Khắc phục Lỗi #CALC! trong Excel: Hướng dẫn Xử lý Sự cố Mảng Động

#CALC!
excelmang-dongcong-thucloi-spill
excelintermediate

Cách khắc phục lỗi 'Cannot shift objects off sheet' trong Excel

Cannot shift objects off sheet
excelsua-loi-bang-tinhdoi-tuong-excelvba
excelintermediate

Sửa lỗi 'Excel cannot complete this task with available resources' Khi Xử Lý Dữ Liệu Lớn

Excel cannot complete this task with available resources. Choose less data or close other applications.
excelbộ nhớtài nguyênhiệu suất
excelbeginner

Sửa lỗi #NAME? trong Excel — Gõ sai tên hàm hoặc thiếu dấu nháy trong công thức

#NAME?
excelcông thứccú pháplỗi-name
excelbeginner

Sửa lỗi Excel bị kẹt ở Protected View: PROTECTED VIEW Be careful—files from the Internet can contain viruses

PROTECTED VIEW Be careful—files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
excelprotected-viewbảo-mậttrusted-location
excelbeginner

Sửa lỗi #SPILL! trong Excel khi công thức mảng động bị chặn đầu ra

#SPILL!
excelmảng-độnglỗi-spillcông-thức
excelintermediate

Sửa lỗi 'DataSource.Error: OLE DB or ODBC error' trong Power Query khi kết nối cơ sở dữ liệu

DataSource.Error: OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
power-queryodbcole-dbdata-source
excelintermediate

Sửa lỗi 'We couldn't get data from the Data Model' – Power Pivot Engine Không Tải Được

We couldn't get data from the Data Model. Here's the error message we got: The Power Pivot engine failed to load.
power-pivotdata-modelexcel-pivot
excelintermediate

Cách khắc phục lỗi 'Too many different cell formats' trong Microsoft Excel

Too many different cell formats.
exceldinh-dang-oxlsxdinh-dang
excelintermediate

Sửa lỗi Formula.Firewall trong Power Query: Hướng dẫn chi tiết từng bước

Formula.Firewall: Query 'QueryName' (step 'StepName') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
power-queryquyen-rieng-tu-du-lieuloi-excel
excelintermediate

Làm chủ lỗi VBA 438: Object Doesn't Support This Property or Method

excelbeginner

Khắc phục lỗi #NUM! trong Excel: Xử lý các phép toán không hợp lệ và tràn tính toán

#NUM!
excelcong-thuckhac-phuc-loiphan-tich-du-lieu
excelbeginner

Sửa lỗi #VALUE!: Khi công thức Excel gặp dữ liệu sai định dạng

#VALUE! - The formula has the wrong type of argument or operand
excelcong-thucloi-valuekhac-phuc-loi
excelintermediate

Cách khắc phục lỗi 'Microsoft.ACE.OLEDB.12.0 provider is not registered'

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
exceloledbket-noi-co-so-du-lieudotnet
excelbeginner

Cách sửa lỗi 'Run-time error 9: Subscript out of range' trong Excel VBA

Run-time error '9': Subscript out of range
excelvbakhắc-phục-lỗimẹo-lập-trình
excelbeginner

Cách sửa lỗi #N/A trong Excel VLOOKUP: Hướng dẫn chi tiết

#N/A - Value is not available to the formula or function (VLOOKUP)
excelvlookupcong-thuctim-kiem
excelintermediate

Khắc phục lỗi 'Column of the Table Wasn't Found' trong Power Query

DataFormat.Error: The column 'ColumnName' of the table wasn't found.
excelpower-querydata-format-errorm-language
excelintermediate

Khắc phục lỗi Excel 'File is Locked for Editing': Hướng dẫn dành cho Quản trị viên hệ thống

This file is locked for editing by another user
exceltroubleshootingwindows-serversmb
excelbeginner

Sửa lỗi 'PivotTable field name is not valid' trong Excel

PivotTable field name is not valid
excelpivot-tablelam-sach-du-lieuloi-excel
excelintermediate

Khắc phục lỗi #DIV/0! trong Excel khi công thức chia cho số 0 hoặc ô trống

excelbeginner

Sửa lỗi Excel: The file format or file extension is not valid

The file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
excelđịnh dạng filefile bị hỏngxlsx
excelintermediate

Sửa lỗi Excel Recovery Mode: "Excel was able to open the file by repairing or removing the unreadable content"

Excel was able to open the file by repairing or removing the unreadable content
excelrecoverysửa chữafile bị hỏng
excelbeginner

Sửa lỗi Excel Macros Have Been Disabled — VBA Macro Bị Chặn Bởi Security

Macros have been disabled. Macros might contain viruses or other security hazards.
excelmacrobảo mậtvba
excelbeginner

Sửa lỗi #REF! trong Excel: Tham chiếu ô không hợp lệ sau khi xóa hàng hoặc cột

#REF! - The formula contains invalid cell references
excelcông thứctham chiếulỗi-ref
excelbeginner

Sửa lỗi "Circular Reference" trong Excel: Công thức tham chiếu đến chính ô chứa nó

There are one or more circular references where a formula refers to its own cell either directly or indirectly
excelcircular-referenceformulacalculation
excelintermediate

Sửa Lỗi Excel "There isn't enough memory to complete this action" Khi Mở File Lớn

There isn't enough memory to complete this action. Try using less data or closing other applications.
excelbộ-nhớhiệu-năngfile-lớn
excelbeginner

Sửa Lỗi #VALUE! Trong Excel: Sai Kiểu Dữ Liệu Trong Công Thức

#VALUE!
excelcông thứclỗi-value
excelintermediate

Sửa lỗi VBA Runtime Error 1004: Application-defined or Object-defined Error trong Excel Macro

Run-time error '1004': Application-defined or object-defined error
excelvbamacroruntime-error