Excel Data Link Formatting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello,
I have found posts about this issue but none of them seem to have a clear answer.
I have inserted an excel sheet using a data link, I format the table with text height, row height, alignment, etc.. I use a break to fit the table onto the desired layout. Then save and close the layout. When I re-open the layout the side that was broken away from expands to some weird formatting. Please see the attached screenshots for before saving and exiting and when I re-open the file.
I have gone into the data link settings and removed the excel formatting option, I have tried every possible combination of locking I can think of.
If someone could provide a solution for this you would be my hero.
Thank you
How I want it to be formatted
After saving and closing the file.