I've started using tables linked to excel files for drawing index on cover sheets. My problem is when I delete or add lines on my excel sheet it changes the format on some of the cells changing font size and justification on some cells of my table. The changes to my table seems random.
Any similar problems out there? Any work arounds?
The items that change on my table are the text size,which increases or decreases and sometimes the justification of the text. The table itself does not change other than the cells that were added/deleted. The format change happens only to text in the cells in close proximity to the cells that were either added/deleted on the excel sheet. Hope this makes more sense.
After adding or deleting an excel row, the linked object should be deleted and the file relinked. There is no other way that works well. The alternative is to avoid inserting and deleting rows and instead copy/move information between rows. You can leave a few blank rows in your linked reference that might get filled later.