Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Excel link in PowerPoint doesn't work in different language versions


View products that this article applies to.

Symptoms

If you paste a range from Excel as a linked object in PowerPoint (Paste Special > Paste As Link), and then open the same file in a copy of Office with a different display language and update the links, you will find that the specific range you pasted gets expanded to the entire used range of the spreadsheet. 

Example:
  1. Create a spreadsheet in English with data in the range A1 to A5, and also in C20.
  2. Copy the A1 to A5 range.
  3. In PowerPoint, choose Paste Special, and then Paste As Link. Save the file.
  4. Open the file in PowerPoint with German as the display language. The linked object will display the range A1 to C20.

↑ Back to the top


Cause

The range is stored in a language locale-specific format. When PowerPoint tries to retrieve the data range using the other language locale, and Excel doesn't understand it and returns the full used range in the spreadsheet.

↑ Back to the top


Resolution

Before copying the range in Excel (step 2 in the example above), name the range of cells.

This will make sure the range is identified correctly in the linked object across all language versions.


↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 3210991
Revision : 3
Created on : 9/25/2018
Published on : 9/25/2018
Exists online : False
Views : 263