This article describes update KB3114404 for Microsoft Office 2010, which was released on December 8, 2015. This update has a prerequisite.

Improvements and fixes

Fixes the following issue:

When you export data to an .xlsx file in Access 2010, half-width spaces are deleted.

Note Be default, the white space is trimmed after export. However, you can enable this feature by following the instructions in the Registry information section.

How to download and install the update

Microsoft Update

Use Microsoft Update to automatically download and install the update.

Microsoft Update Catalog

To get the stand-alone package for this update, go to the Microsoft Update Catalog website.

If you're not sure what platform (32-bit or 64-bit) you're running, see Am I running 32-bit or 64-bit Office? Additionally, see more information about how to download Microsoft support files.

Microsoft scanned this file for viruses by using the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to it.

Update information

Registry informationImportant
Follow the steps in this section carefully. Serious problems might occur if you change the registry incorrectly. Before you change it, back up the registry for restoration in case problems occur.

After you install this update, follow these steps to set a registry key so that the white space isn't trimmed after export.

  1. Exit all Microsoft Office applications.

  2. Start Registry Editor:

    • In Windows 10, go to Start, enter regedit in the Search Windows box, and then select regedit.exe in the search results.

    • In Windows 8 or Windows 8.1, if you're using a mouse, move it to the upper-right corner, go to Search, enter regedit in the search text box, and then select regedit.exe in the search results.

    • In Windows 7, go to Start, enter regedit in the Search programs and files text box, and then select regedit.exe in the search results.

  3. Locate and then select the following registry entry:

    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Settings\

  4. On the Edit menu, point to New, and then select DWORD Value.

  5. Enter PreserveCellWhiteSpace, and then press the Enter key.

  6. In the Details pane, press and hold (or right-click) PreserveCellWhiteSpace, and then select Modify.

  7. In the Value data box, enter 1, and then select OK.

  8. Exit Registry Editor.

Restart informationYou may have to restart the computer after you install this update.

PrerequisiteTo apply this update, you must have Microsoft Office 2010 Service Pack 2 installed.

More Information

Windows 10

  1. Go to Start, enter View Installed Updates in the Search Windows box, and then press Enter.

  2. In the list of updates, locate and then select update KB3114404, and then select Uninstall.

Windows 8 and Windows 8.1

  1. Swipe in from the right edge of the screen, and then select Search. If you're using a mouse, point to the lower-right corner of the screen, and then select Search.

  2. Enter windows update, select Windows Update, and then select Installed Updates.

  3. In the list of updates, locate and then select update KB3114404, and then select Uninstall.

Windows 7, Windows Vista and Windows XP

  1. Go to Start, enter Run, and then select Run.

  2. Enter Appwiz.cpl, and then select OK.

  3. Use one of the following procedures, depending on the operating system that you're running.

    • Windows 7 and Windows Vista

      1. Select View installed updates.

      2. In the list of updates, locate and select update KB3114404, and then select Uninstall.

    • Windows XP

      1. Select the Show updates check box.

      2. In the list of updates, locate and select update KB3114404, and then select Remove.


References

Learn about the standard terminology that Microsoft uses to describe software updates. The Office System TechCenter contains the latest administrative updates and strategic deployment resources for all versions of Office.

File Information

The global version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

ace-x-none.msp file information

File identifier

File name

File version

File size

Date

Time

Acecore.dll

Acecore.dll

14.0.7159.5000

2,184,808

05-Sep-2015

13:22

Acacedao.dll

Acedao.dll

14.0.7161.5000

545,024

01-Oct-2015

22:21

Acedao.dll

Acedao.dll

14.0.7161.5000

545,024

01-Oct-2015

22:21

Aceerr.dll

Aceerr.dll

14.0.7159.5000

38,520

05-Sep-2015

13:22

Acees.dll

Acees.dll

14.0.7159.5000

647,920

05-Sep-2015

13:22

Aceexch.dll

Aceexch.dll

14.0.7159.5000

337,024

05-Sep-2015

13:22

Aceexcl.dll

Aceexcl.dll

14.0.7164.5000

646,880

12-Nov-2015

00:57

Aceodbc.dll

Aceodbc.dll

14.0.7159.5000

279,800

02-Sep-2015

12:11

Aceoddbs.dll

Aceoddbs.dll

14.0.7005.1000

15,536

01-Nov-2012

01:51

Aceodexl.dll

Aceodexl.dll

14.0.7005.1000

15,536

01-Nov-2012

01:51

Aceodtxt.dll

Aceodtxt.dll

14.0.7005.1000

15,528

01-Nov-2012

01:51

Aceoledb.dll

Aceoledb.dll

14.0.7159.5000

378,088

05-Sep-2015

13:22

Acer3x.dll

Acer3x.dll

14.0.7159.5000

331,896

02-Sep-2015

12:11

Acerclr.dll

Acerclr.dll

14.0.7159.5000

47,264

02-Sep-2015

12:11

Acerep.dll

Acerep.dll

14.0.7159.5000

530,056

05-Sep-2015

13:22

Acetxt.dll

Acetxt.dll

14.0.7159.5000

222,840

05-Sep-2015

13:22

Acexbe.dll

Acexbe.dll

14.0.7159.5000

365,176

05-Sep-2015

13:22

Expsrv.dll

Expsrv.dll

6.1.0.1628

454,744

10-Dec-2012

18:49

Vbajet32.dll

Vbajet32.dll

6.0.1.1628

50,272

10-Dec-2012

18:49


ace-x-none.msp file information

File identifier

File name

File version

File size

Date

Time

Acecore.dll

Acecore.dll

14.0.7159.5000

2,638,952

05-Sep-2015

13:22

Acacedao.dll

Acedao.dll

14.0.7161.5000

734,464

01-Oct-2015

22:21

Acedao.dll

Acedao.dll

14.0.7161.5000

734,464

01-Oct-2015

22:21

Aceerr.dll

Aceerr.dll

14.0.7159.5000

43,128

05-Sep-2015

13:22

Acees.dll

Acees.dll

14.0.7159.5000

936,072

05-Sep-2015

13:22

Aceexch.dll

Aceexch.dll

14.0.7159.5000

444,544

05-Sep-2015

13:22

Aceexcl.dll

Aceexcl.dll

14.0.7164.5000

901,856

12-Nov-2015

01:02

Aceodbc.dll

Aceodbc.dll

14.0.7159.5000

345,752

02-Sep-2015

12:07

Aceoddbs.dll

Aceoddbs.dll

14.0.7005.1000

16,536

01-Nov-2012

02:07

Aceodexl.dll

Aceodexl.dll

14.0.7005.1000

16,536

01-Nov-2012

02:07

Aceodtxt.dll

Aceodtxt.dll

14.0.7005.1000

16,536

01-Nov-2012

02:07

Aceoledb.dll

Aceoledb.dll

14.0.7159.5000

523,912

05-Sep-2015

13:22

Acer3x.dll

Acer3x.dll

14.0.7159.5000

453,752

02-Sep-2015

12:07

Acerclr.dll

Acerclr.dll

14.0.7159.5000

58,016

02-Sep-2015

12:07

Acerep.dll

Acerep.dll

14.0.7159.5000

693,896

05-Sep-2015

13:22

Acetxt.dll

Acetxt.dll

14.0.7159.5000

299,640

05-Sep-2015

13:22

Acexbe.dll

Acexbe.dll

14.0.7159.5000

504,440

05-Sep-2015

13:22

Expsrv.dll

Expsrv.dll

6.1.0.1628

520,280

10-Dec-2012

18:49

Vbajet32.dll

Vbajet32.dll

6.0.1.1628

50,784

10-Dec-2012

18:49


Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×