Linking Excel data to Publisher

%3CLINGO-SUB%20id%3D%22lingo-sub-2562766%22%20slang%3D%22en-US%22%3ELinking%20Excel%20data%20to%20Publisher%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2562766%22%20slang%3D%22en-US%22%3E%3CP%3EI%20copied%20CTRL%2BC%20data%20from%20Excel%20and%20pasted%20Home%26gt%3BPaste%26gt%3BPaste%20Special%2FPaste%20Link%20in%20Publisher.%20It%20came%20in%20as%20a%20linked%20table%20which%20I%20can%20format%20at%20will%20%E2%80%93%20all%20borders%20%2F%20outside%20borders%20and%20I%20can%20enter%20the%20cells%20and%20change%20e.g.%20font%20colour.%3C%2FP%3E%3CP%3EWhen%20I%20repeated%20this%20action%20with%20data%20from%20the%20same%20Excel%20file%2C%20a%20few%20rows%20further%20down%20and%20linking%20to%20the%20same%20Publisher%20file%20%E2%80%93%20one%20page%20later%20-%20it%20came%20in%20as%20a%20linked%20object%20which%20I%20can%20format%26nbsp%3B%20-%20outside%20borders%20but%20not%20all%20(i.e.%20inner%20borders)%20and%20I%20can%20not%20enter%20the%20cells%20to%20change%20the%20font%20colour.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20paste%20using%20right-mouse%20but%20then%20the%20table%20is%20not%20linked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20why%3F%20To%20the%20best%20of%20my%20awareness%20I%20haven't%20done%20anything%20differently.%3C%2FP%3E%3CP%3EThanks%20for%20any%20insights.%20Dennis%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2562766%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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