This article describes update KB3039750 for Microsoft Office 2013, which was released on November 1, 2016. This update also applies to Office Home and Student 2013 RT. This update has a prerequisite.

Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2013. It doesn't apply to the Office 2013 Click-to-Run editions, such as Microsoft Office 365 Home. (How to determine?)

Improvements and fixes

Fixes the following issue:

When you export data from Access 2010 to Excel, white space in string data isn't preserved.

Note By 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.

Download Center

This update is also available for manual download and installation from the Microsoft Download Center. The updates in the Download Center can't be installed on Office Home and Student 2013 RT.

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\15.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.

PrerequisiteTo apply this update, you must have Microsoft Office 2013 Service Pack 1 installed.

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

More Information

To determine whether your Office installation is Click-to-Run or MSI-based, follow these steps:

  1. Start an Office 2013 application, such as Microsoft Word 2013.

  2. On the File menu, select Account.

  3. For Office 2013 Click-to-Run installations, an Update Options item is displayed. For MSI-based installations, the Update Options item isn't displayed.

Office 2013 Click-to-Run installation

MSI-based Office 2013

The screenshot for Word Click To Run

The screenshot for Word MSI

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 KB3039750, and then select Uninstall.

Windows 8 and Windows 8.1

  1. Swipe in from the right edge of the screen, and then tap 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 KB3039750, and then select Uninstall.

Windows 7

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

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

  3. Select View installed updates.

  4. In the list of updates, locate and then select update KB3039750, and then select Uninstall.


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

15.0.4873.1000

2,282,768

11-Oct-2016

04:17

Acacedao.dll

Acedao.dll

15.0.4787.1000

617,728

11-Oct-2016

04:17

Acedao.dll

Acedao.dll

15.0.4787.1000

617,728

11-Oct-2016

04:17

Aceerr.dll

Aceerr.dll

15.0.4543.1000

40,664

11-Oct-2016

04:17

Acees.dll

Acees.dll

15.0.4873.1000

887,128

11-Oct-2016

04:17

Aceexch.dll

Aceexch.dll

15.0.4873.1000

257,352

11-Oct-2016

04:17

Aceexcl.dll

Aceexcl.dll

15.0.4873.1000

542,512

11-Oct-2016

04:17

Aceintl.dll_1033

Aceintl.dll

15.0.4454.1000

201,368

12-Oct-2016

02:26

Aceodbc.dll

Aceodbc.dll

15.0.4695.1000

337,648

11-Oct-2016

04:17

Aceodbci.dll_1033

Aceodbci.dll

15.0.4454.1000

53,392

12-Oct-2016

02:26

Aceodexl.dll

Aceodexl.dll

15.0.4454.1000

16,536

11-Oct-2016

04:17

Aceodtxt.dll

Aceodtxt.dll

15.0.4454.1000

16,536

11-Oct-2016

04:17

Aceoledb.dll

Aceoledb.dll

15.0.4873.1000

454,984

11-Oct-2016

04:17

Acetxt.dll

Acetxt.dll

15.0.4869.1000

212,784

11-Oct-2016

04:17

Acewdat.dll

Acewdat.dll

15.0.4695.1000

3,051,744

11-Oct-2016

04:17

Acewstr.dll_1033

Acewstr.dll

15.0.4695.1000

859,344

12-Oct-2016

02:26


ace-x-none.msp file information

File identifier

File name

File version

File size

Date

Time

Acecore.dll

Acecore.dll

15.0.4873.1000

1,680,152

11-Oct-2016

04:15

Acacedao.dll

Acedao.dll

15.0.4787.1000

432,384

11-Oct-2016

04:14

Acedao.dll

Acedao.dll

15.0.4787.1000

432,384

11-Oct-2016

04:14

Aceerr.dll

Aceerr.dll

15.0.4569.1501

35,032

11-Oct-2016

04:15

Acees.dll

Acees.dll

15.0.4873.1000

633,688

11-Oct-2016

04:15

Aceexch.dll

Aceexch.dll

15.0.4569.1501

186,600

11-Oct-2016

04:15

Aceexcl.dll

Aceexcl.dll

15.0.4873.1000

400,184

11-Oct-2016

04:15

Aceintl.dll_1033

Aceintl.dll

15.0.4454.1000

199,816

12-Oct-2016

02:21

Aceodbc.dll

Aceodbc.dll

15.0.4695.1000

278,256

11-Oct-2016

04:15

Aceodbci.dll_1033

Aceodbci.dll

15.0.4454.1000

51,856

12-Oct-2016

02:21

Aceodexl.dll

Aceodexl.dll

15.0.4454.1000

15,000

11-Oct-2016

04:15

Aceodtxt.dll

Aceodtxt.dll

15.0.4454.1000

15,016

11-Oct-2016

04:15

Aceoledb.dll

Aceoledb.dll

15.0.4873.1000

329,552

11-Oct-2016

04:15

Acetxt.dll

Acetxt.dll

15.0.4763.1000

161,400

11-Oct-2016

04:15

Acewdat.dll

Acewdat.dll

15.0.4695.1000

3,049,184

11-Oct-2016

04:15

Acewstr.dll_1033

Acewstr.dll

15.0.4695.1000

852,184

12-Oct-2016

02:21


Need more help?

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

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×