Linking Excel data to Publisher

Contributor

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.

Thanks for any insights. Dennis

0 Replies