LỖI ERROR WERE DETECTED WHILE SAVING EXCEL 2010

Problem

Consider the following scenario: You are working on a project to lớn automate Microsoft Office. Therefore, you have sầu opened the Microsoft Visual Basic for Applications editor. An Excel worksheet is open as well, which contains a appmobiles.info Excel data links (see Excel data links).

Bạn đang xem: Lỗi error were detected while saving excel 2010

You delete the Excel worksheet where appmobiles.info"s Excel data links resides. Excel may show an error message: "Object required".

If you try khổng lồ save the Excel file, Excel shows an error message: "Errors were detected while saving . Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, cliông xã Continue. To cancel saving the file, clichồng Cancel."

*
When you clichồng Continue, the repair fails.

Excel2007 or 2010: Excel crashes if you try to lớn insert a new Excel worksheet instead of trying lớn save sầu the tệp tin.

Cause


Reproduction without appmobiles.info

Please perkhung the following steps:

Start Excel with a new empty file.Enter 100 in cells A1 & A2 on the first worksheet, Sheet1.Select the cells A1:A2 on Sheet1 & press Ctrl + C to lớn copy.(Only if you try khổng lồ reproduce with Excel2013 or later: Insert a second worksheet. Older Excel versions have three mặc định worksheets, so this is not required).Press Alt + F11 khổng lồ open the Microsoft Visual Basic for Applications editor window, & leave it open.Start Word with a new empty tệp tin.In Word, go toHome→ Paste→ Paste Special→ Paste Link: Microsoft Excel Worksheet Object& cliông xã OK.In Excel, right-cliông xã the Sheet1 tab và cliông chồng Delete.

Xem thêm: Không Mặc Quần Lót Cho Thoải Mái, Sức Khỏe Của “Cậu Nhỏ” Có Bị Ảnh Hưởng Không?

Try lớn save sầu the Excel file. Excel shows an error message: "Errors were detected while saving . Microsoft Excel may be able lớn save sầu the file by removing or repairing some features. To make the repairs in a new tệp tin, click Continue. To cancel saving the tệp tin, cliông chồng Cancel."

When you clichồng Continue, the repair fails.

Excel2007 or 2010: Excel crashes if you try to insert a new Excel worksheet instead of trying khổng lồ save sầu the file.


Solution

If you encounter this error, you can save sầu your data in a new Excel document or disthẻ the changes và repair the original document:

Save sầu your data in a new Excel document

To save sầu changes you made khổng lồ your document, copy the worksheets you changed to lớn a new Excel document và save it.

Repair your Excel document lớn avoid this error in the future

You can repair your Excel document by deleting any Visual Basic for Applications (VBA) projects from your document.However, simply deleting them in the Visual Basic editor is not sufficient.Please use the following procedure:


Create a backup of your document.mở cửa your document in the Structured Storage Viewer.In the tree view of your document, select_VBA_PROJECT_CUR và press Del to lớn delete it.Confirm deletion and cthua thảm the Structured Storage Viewer.xuất hiện the document in Excel.There will be a dialog box Microsoft Visual Basic→ File not found. Hit OK.There will be another dialog box Repairs,with Lost Visual Basic projectlisted. Hit Cthất bại.Save your document.

You should now be able khổng lồ delete the worksheet with appmobiles.info link and then save sầu the document.