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.
- Create a spreadsheet in English with data in the range A1 to A5, and also in C20.
- Copy the A1 to A5 range.
- In PowerPoint, choose Paste Special, and then Paste As Link. Save the file.
- Open the file in PowerPoint with German as the display language. The linked object will display the range A1 to C20.
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.
Article ID: 3210991 - Last Review: Dec 7, 2016 - Revision: 1
PowerPoint 2016, Microsoft PowerPoint 2013, Microsoft PowerPoint 2010, Microsoft Office PowerPoint 2007, Microsoft Office PowerPoint 2003, Microsoft PowerPoint 2000 Standard Edition, Excel 2016, Microsoft Excel 2013, Microsoft Excel 2010, Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2000 Standard Edition