Microsoft Excel For Mac Found Problem With Some Content

-->

When does the problem begin to occur and have you ever done anything that might cause it? You mentioned that “Excel for mac did this on a previous mac which we replaced”, since the issue occurred to two devices, how do you set up your new Mac, manually or using Migration Assistant? Sometime the old user profiles could cause some problems.

Summary

You may have problems when you try to save a Microsoft Excel workbook if one or more of the following conditions are true:

• You save an Excel workbook to a network drive on which you have restricted permissions.
• You save an Excel workbook to a location that does not have sufficient drive space.
• The connection to the Excel workbook is lost.
• There is a conflict with an antivirus software program.
• You save an Excel workbook that is shared.
• The 218-character path limitation is exceeded when you save an Excel workbook.

Workarounds and resolutions

The following sections include workarounds to save your workbooks and troubleshooting steps to help you find the cause of the problem. We recommend that you first try to save changes in any open Excel workbooks before you start troubleshooting.

Workarounds to save Excel workbooks

To work around this problem and try to save your work before you troubleshoot, use the following methods. Depending on the cause of the problem, you may be unable to recover the current file as-is. However, the following methods are typically successful. These methods are listed in order of format retention when you are trying to keep the original file formatting.

Note

The following methods may not save all the latest changes, formatting, and feature sets of the workbook that are specific to the version of Excel that you are using. The following methods are intended to let you obtain a usable, saved version of the file. These methods require you to save the file to your local hard disk by using a unique file name.

Method 1: Save the workbook by using a new file name

1. On the File menu, select Save As.
2. Save the Excel workbook by using a unique file name.

Method 2: Move the original worksheets to a new workbook

1. Add a filler worksheet to your workbook. To do this, press Shift + F11.

   Note

   This sheet is required because there has to be at least one remaining sheet in a workbook after you move all relevant data sheets.

2. Group all the worksheets (except the filler). To do this, select the first sheet, hold the Shift key, and then select the last sheet.

3. Right-select the grouped sheets, and then select Move or copy.

4. In the To Book list, select (New Book).

5. Select OK.

   Note

   These steps should move the active (grouped) worksheets to a new workbook.

If your workbook contains VBA macros, copy the modules from the old workbook to the new workbook.

Method 3: Save the file as a different Excel file type

1. On the File menu, select Save As.
2. In the Save as Type list, select a file format other than the current file format. If you are using Microsoft Excel 2007 or a later version, save the file as .xlsx or .xlsm instead of as .xls.

Troubleshooting

To troubleshoot this problem, follow these steps in the given order.

Step 1: Try to save the workbook to another location

Try saving your notebook to another location, such as a local hard drive, a network drive, or removable drive. If you are successful, the following are possible causes of the problem:

Step 2: Try to save a new workbook to the original location

To save a new Excel file to the original location, follow these steps:

1. Create an Excel workbook.

2. On the File menu, select Save As.

3. In the Save As dialog box, follow these steps:

   1. In the Save in box, select the location in which the original workbook is saved.
   2. In the File name box, type a name for the new file.
   3. Select Save.

If you can save a new workbook to the original location, the following are possible causes of the problem:

If you cannot save a new workbook to the original location, the following is a possible cause of the problem:

If you have sufficient drive space, try Step 3.

Step 3: Try to save the workbook in safe mode

Restart Windows in safe mode, and then try to save the workbook to your local hard disk.

Notes

• If you use a network location to save your workbook, try to restart Windows in safe mode with network support, and then try to save.
• Windows safe mode cannot be used to troubleshoot issues in Microsoft Excel 2010 or later versions.

For more information about how to start Windows in safe mode, see Advanced startup options (including safe mode).

If the workbook saves after you restart Windows in safe mode, try to save the file again. To do this, select Save on the File menu.

If the workbook does not save (or save again) after you restart Windows in safe mode, the following are possible causes:

Causes

Third-party add-in

If the Excel file is not saved when you run Excel in Windows safe mode, the issue may be caused by a third-party add-in or by a file that is in one of the Excel startup locations. By default, these files are loaded when you start Excel.

Sometimes, third-party software vendors install custom add-ins to work with Excel. Some of these add-ins work with existing Excel features by design, and some are intended to enable a seamless transition when you are using a third-party product. Typically, these third-party add-ins do not interfere with normal Excel functionality. However, there are some exceptions. For example, Excel save conflicts have occurred because of an add-in.

To test for and eliminate the possibility that a third-party Excel add-in or file is causing an Excel save issue, start Excel in safe mode. To do this, follow these steps:

1. Exit Excel.

2. Select Start, and then point to Programs.

3. Press Ctrl when you start Excel, and hold it until you receive a message that resembles the following:

   Excel has detected that you are holding down the Ctrl key. Do you want to start Excel in safe mode?

4. Select Yes.

5. Try to save a new Excel file, and then resave the same Excel file again.

If the file saves correctly, a custom add-in or a file that is located in an Excel startup location is most likely the cause. You must locate and remove the add-in or the file to eliminate the problem. After you determine the add-in or the file that caused the problem, contact the vendor that designed it. The vendor may have additional information about this issue and an update that does not cause the issue to occur.

For more information about Microsoft Excel safe mode, press F1 in Excel to open the Help menu, type safe modein the Search box, and then select Search to view the topic.

For more information about how to determine the folders that Excel uses during startup and additional options to disable this functionality, select the following article numbers to view the articles in the Microsoft Knowledge Base:

822107 How to use startup folders in Excel

826922 How to prevent files from opening automatically in Excel

Restricted permissions

When you save an Excel file, you must have the following permissions to the folder in which you are saving the file:

• Read permission
• Write permission
• Modify permission
• Delete permission

Note

If you do not have these permissions, the Excel save process cannot be completed.

Insufficient drive space

When you save to any medium, such as a floppy disk drive, a local hard disk, or a network drive, you must make sure that the drive has sufficient free space to enable the file to save. If the destination drive does not have sufficient space, Excel cannot complete the save operation, and you receive the following error message: Disk is Full.

For more information about this error message, select the following article numbers to view the articles in the Microsoft Knowledge Base:

214245 You receive the 'Disk is Full' error message when you save a workbook in Excel

214073 You receive an error message when you try to save a file in Excel

Antivirus software conflict

When antivirus software is installed or is running, you may receive an error message when you try to save an existing workbook. You do not receive an error message if you try to save a new file. You may receive an error message because some antivirus programs quickly scan any new files that appear on a computer. This scan can sometimes disrupt the Excel save process. This interruption may stop Excel from saving the file correctly.

File sharing conflict

If you and a second user work concurrently on a shared workbook, you may receive an error message if you and the second user try to save the file at the same time. You receive an error message because Excel cannot save the file if another instance of Excel is saving the same file.

For more information about this error message, see the following Microsoft Knowledge Base article:

130494 Unlock a file that has been locked for editing

File name length

If you try to save or open an Excel file, and the path of that file (including the file name) is more than 218 characters, you may receive the following error message: Filename is not valid.

For more information, select the following article number to view the article in the Microsoft Knowledge Base: 213983 Error message when you open or save a file in Microsoft Excel: 'Filename is not valid'

Process to save a file

Excel follows these steps when it saves a file:

1. Excel creates a randomly named temporary file (for example, Cedd4100 without a file name extension) in the destination folder that you specified in the Save As dialog box. The whole workbook is written to the temporary file.
2. If changes are being saved to an existing file, Excel deletes the original file.
3. Excel renames the temporary file. Excel gives the temporary file the file name that you specified (such as Book1.xls) in the Save As dialog box.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

814068 Description of the way that Excel saves files

Note

Other processes that occur on your computer may disrupt the Excel save process. These issues may occur if the Excel temporary file is accessed before the Excel save process is completed. For example, the local antivirus software locks the temporary file for scanning before the file can be renamed. Therefore, you must keep track of any new software installations or updates that are performed before you have problems when you try to save workbooks. This information will be helpful if this article does not fix your issue and you have to contact Microsoft Support. For more information, go to the following Microsoft website: http:/support.microsoft.com

Nov 26,2019 • Filed to: Recover & Repair Files • Proven solutions

'We found a problem with some content in . Do you want us to try recover as much as we can? If you trust the source of this workbook, click yes'

Part 1: What is the Error cause Excel File get Corrupted

The cause of the error, are usually due to:

• a). some error in any add-ins in the third party software.
• b). If a string is added to a cell instead of number this error may come. This can also happen if a string is added which is convertible to a number.

A few scenarios where Excel sheet gets corrupted are as below:

1. Improper shutdown of the system: Many times computer system undergo sudden shutdown due to power supply failure or any similar reason. However, shutting down the system normally but without properly closing all the running applications may also cause damaging effects to files and data to a similar degree. MS Excel files also get damaged or corrupted due to such reasons.
2. Virus: Computer viruses which are programs maliciously designed to infect source or data files on a computer, often at a very large scale. A computer system contaminated with the virus can be a cause of Excel files getting corrupted.
3. Bad sectors on a storage device: The storage devices e.g. hard drive (local), hard drive (external) pen drive, etc. may get developed bad sectors over some period of time, which is basically a hardware problem, Excel sheet on these bad sectors of storage media can get corrupt.
4. Improper handling of MS Excel: An unexpected closing of Excel sheet or improper closing of an opened file can be a cause of corrupted Excel file.
5. Large data size: Basically MS Excel is not meant for handling huge data as it is not a database, therefore, chances of corruption become more if you overload excel file to contain a large amount of data.
6. Software conflict: Sometimes software conflicts as well as, rarely, though, printing excel file may also be the cause of damaging excel files.
7. Macros and Formulas: Excel Macros and complex formulas also have a known bad reputation of creating corrupted data in a working worksheet.

Part 2: With 'Open and Repair' feature to Repair corrupt Excel file

To repair Excel workbook (Excel 2013) with the type of error message: 'We found a problem with some content in <filename>. Do you want us to try recover as much as we can? If you trust the source of this workbook, click yes'

That appears with Excel 2007/2010 as well, there are five methods to recover corrupted file.

1.Restore (from Backup). The file can be restored from the backup whereas backup must be maintained automatically.

2.Restore (from Recovery file). This is an alternative to backup, a file comprising all the Excel data that you can fetch back even if data is deleted or damaged accidentally. To do this mark ‘check’ in every box of “Save AutoRecovery” in the Excel Options, except ‘Disable AutoRecover’.

3.Recover from Office Document. This option is available only when the file is slightly affected. In the task pane of documentary recovery, arrow near recovered file may be clicked and ‘Save AS’ option enables recovery.

4.Open and Repair” feature. Excel automatically starts attempting recovery is the case it detects any corrupt Excel 2013 file, as the facility is provided in MS Excel itself. But failure to this mode, manual recovery is achievable by “Open and Repair” feature. Follow these steps.

• Open Excel
• Click File -> Open.
• Browse. Select corrupted worksheet.
• From pull-down menu (pressing arrow of Open button) click ‘Open and Repair’.

5.Third-party Tools.

In case none of these options recover Excel 2013 file properly, best professional Excel Repair software ‘Stellar Phoenix Excel Repair’ should be used to fix all errors.

Part 3: Repair MS Excel File with Excel Repair Tool

Stellar Phoenix Excel Repair is an Excel file repair software. The demo version is free to let the novice experience comfortably. It is a must have excel file repair software that flawlessly repairs corrupted excel file. This excel file repair software offers two licensed versions, one for a single user and other for multiple systems are available supporting Mac (Excel2011) and all versions of windows.

• Repairs all kind of data stored in damaged excel file such as tables, charts, formulas, comments, images, etc.
• Restore all of your corrupted excel files to their original standing.
• Preview the repaired excel file in real-time,see how much of the file has been recovered as it is being repaired.
• All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
• This excel file repair tool can be used on both windows and Mac platforms in order to repair corrupt excel file.
• All kind of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
• This excel file repair tool can repair damaged files of all versions from 2000 to 2016 that includes 2000, 2003, 2007, 2010, 2013, etc.

Simple steps to perform Excle File Repair

For Windows, the following sequence of steps may be followed to easily repair corrupted excel file, corrupted or damaged. For Mac, the option is there and can be used the same way. This Excel file repair software works equally well on either of the two to repair corrupted excel file.

Step 1 Benq sw2700pt drivers mac.

Step 2

Step 3

Step 4

Part 4: Tips to Repair Corrupted Excel File

Case 1. When Excel cannot open the file

1. Copy and open corrupt file on hard-drive.
2. Find .xlb file. Also keep a backup as well. Delete .xlb. Restart Excel.
3. Try opening the file in MS word or Notepad. However, that will let you recover data but not formatting
4. Use Excel XP. This has better options for recovery.
5. When attempting opening file, disable macros
6. Click start running Excel in safe mode and then enter “C:Program fileMicrosoft officeofficeexcel.exe”/s

Case 2. When Excel file is open

1. Try on a different computer
2. Switch off Auto-save.
3. Turn off the file sharing option
4. Don’t run Excel from a floppy
5. Save the file as a web page and reopen it as Excel file.
6. Decrease size of Excel file
7. Go back to the last version of the file saved.

Precautionary Tips to avoid excel file get corrupted

• Ensure system is shut down properly.
• Always install the latest anti-virus.
• No bad sectors should be there on the storage device.
• Always close Excel properly.
• Avoid huge data handling with Excel.

Recover & Repair Files

Recover Document Files

Repair Document Files

Recover & Repair More

Clear & Delete File