I copied CTRL+C data from Excel and pasted Home>Paste>Paste Special/Paste Link in Publisher. It came in as a linked table which I can format at will – all borders / outside borders and I can enter the cells and change e.g. font colour.
When I repeated this action with data from the same Excel file, a few rows further down and linking to the same Publisher file – one page later - it came in as a linked object which I can format - outside borders but not all (i.e. inner borders) and I can not enter the cells to change the font colour.
I can paste using right-mouse but then the table is not linked.
Any ideas on why? To the best of my awareness I haven't done anything differently.