November 1, 2016, update for Office 2013 (KB3039750)

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

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.

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.