web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Word: Linked Excel Cel...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Word: Linked Excel Cell Alignment in Sentence

(2) Share

Report

Report

Posted on by CU02061919-0

4

Hello. I want to write a sentence with multiple Excel links in the single sentence on one line. I cannot get the linked Excel cells in a Word document to remain in line in a sentence where it is inserted. When it updates it automatically adds a carriage return and the linked cell becomes the beginning of the following line. If I try to put more than one linked cell on a single line they merge to become one sort of combined link. Then when you update one of them one goes away and the other turns into hash marks.

Categories:

Dynamics 365 general

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

DAnny3211 11,389 on at

Like (0)

Report
Word: Linked Excel Cell Alignment in Sentence

Hi,

This issue with linked Excel cells in Word breaking alignment or merging when updated is a known limitation of how Word handles embedded or linked objects—especially when multiple links are placed inline within a sentence.

Here's how you can work around it:

Recommended Approach

Use Inline Shapes Carefully:

When inserting linked Excel cells, ensure they are inserted as inline text, not as floating objects.

Use Paste Special > Paste Link > Unformatted Text if possible. This keeps the link but avoids object formatting issues.

Avoid Multiple Links in One Sentence:

Word tends to treat multiple linked objects in one line as a single compound object, which causes merging or formatting issues.

Instead, consider placing each link in its own content control or table cell to isolate them.

Use a Table for Layout:

Create a single-row table with multiple columns.

Insert each linked cell into a separate column.

This keeps alignment intact and prevents merging.

Use Fields Instead of Objects:

If possible, use Word fields ({ LINK Excel.Sheet.12 ... }) manually inserted via Ctrl+F9. This gives more control over formatting and placement.

Update Links Carefully:

When updating, use Ctrl+A then F9 to update all fields.

Avoid clicking directly on the linked object, which can trigger reformatting or carriage returns.

Best Practice Summary

Use Paste Special with unformatted text.

Isolate links using tables or content controls.

Avoid placing multiple links directly in one sentence.

Use Word fields for advanced control.

Please verify if this helps stabilize your layout and link behavior.

Thanks and best regards,

Daniele

Note: This response was prepared with support from Copilot to ensure clarity and completeness.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

André Arnaud de Cal... 69 Super User 2025 Season 2

#2

CA Neeraj Kumar 60

#3

Sohaib Cheema 50 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans