There's a couple of things I normally do when bringing in Excel spreadsheet data that doesn't seem to work properly. Before applying cell styles or table styles - clear all overrides.
- Select the Table.
- In the Cell Style panel, click on the Clear Overrides in Selection button
- Then in the Table Style panel do the same, and start applying the table or cell styles.
Generally that makes things less temperamental ;-)
I thank you and my hair thanks you (and the fact that it is capable of doing so suggests I should go wash it). You've saved me immeasurable frustration. As soon as I did this the table looked pretty much the way I wanted it to; apparently it had applied my changed but then kept the old overrides overtop of them.
ha ha, I'm glad you got to keep your hair Great to hear that sorted the issue.