I'm using InDesign CC2015.4 and have linked an Excel table to InDesign. I have it all formatted using the cell styles and table styles. When I make a change in Excel and update the link in InDesign, for some reason a hyperlink character style gets applied to the entire table. It's an easy fix (just highlighting the table and making it 'none' on character style and it's all good again) but I'm looking at making 300+ pages of tables and that will get slightly annoying if that happens every time something is updated. What am I doing wrong? I've only been using InDesign for about 1 year so there's a good possibility I'm missing some really small simple thing, I just don't know what.
Thanks, I actually looked at that before and I'm still having issues.I'd like to keep everything linked instead of copy and pasting too. I think I'll try a few other things to see if I can fix it on my own. I've also seen WordsFlow and I'm trying to avoid having to buy something if InDesign can do it.