You cannot save a workbook that contains an image that was copied from another workbook in Excel 2010

Article translations Article translations
Article ID: 2597034 - View products that this article applies to.
Expand all | Collapse all

Symptoms

Consider the following scenario:
  • You copy an image in a previously saved Excel 2010 workbook (.xlsx).
  • You paste the image into another workbook (.xlsx).
  • You close the first workbook.
  • You try to save the workbook that contains the pasted image.
In this scenario, you cannot save the workbook, and you receive the following error message:
Errors were detected while saving '[path\Filename]'. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.

Note This issue also occurs when you copy or move a worksheet that contains an image from one workbook to another workbook and then close the original workbook. If the original workbook contains only one worksheet in this situation, the original workbook closes automatically and you experience this issue.

Resolution

To resolve this issue, apply the following update:
2597142 Description of the Excel 2010 hotfix package (x86 Excel-x-none.msp, x64 Excel-x-none.msp): February 28, 2012


Registry key information

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows

After you install the hotfix package, follow these steps to enable the hotfix: 
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then select the following registry subkey:

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
  3. On the Edit menu, point to New, and then click DWORD (32-bit) value.
  4. Type FullLoadImagesOnFileLoad, and then press ENTER.
  5. In the Details pane, right-click FullLoadImagesOnFileLoad, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 2597034 - Last Review: January 17, 2013 - Revision: 3.0
Applies to
  • Microsoft Excel 2010
Keywords: 
kbqfe kbsurveynew kbexpertisebeginner KB2597034

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com