Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Excel Data Link Formatting

Anonymous

Excel Data Link Formatting

Anonymous
Not applicable

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 formattedHow I want it to be formattedAfter saving and closing the file.After saving and closing the file.

0 Likes
Reply
551 Views
4 Replies
Replies (4)

pendean
Community Legend
Community Legend
Based on the images alone I would say your Excel spreadsheet's own formatting took over again.

0 Likes

Anonymous
Not applicable

This is what I assumed as well. I disabled excel formatting through the data link settings and I still got the same result. I have tried every combination of the available settings and it re-formats every time.

0 Likes

pendean
Community Legend
Community Legend
any chance you can test your method with the same Excel document in a new empty file? If it fails, post both here.

0 Likes

Anonymous
Not applicable

I was able to mess with the formatting in excel to make it work for my specific application. Still have some issues when I adjust cells in excel and then the CAD sheet updates but I think the best route is modifying the formatting in excel.

 

Thank you for responding!

0 Likes