Embedded Excel table in Word Error

[anteagles20]

Hi,

I have an excel xlsm file which I am copying tables of data into a word doc file using paste special link excel object. The tables appear in the word file ok and update as expected. However, when I print the word doc some of the embedded excel tables print with the column/row headings from excel around the outside (even though the headings do not appear when just viewing the file in word). I have noticed that the tables with the error are all from the same tab in the excel file and tables from the other 5 tabs are fine.

I have looked at the headings setting in excel and the headings are visible on all the worksheets. I changed this to false and recopied the data into word but still getting the same issue.

Has anybody got any ideas because this has me stumped?

Thanks

Ant

[6StringJazzer]

I have not seen this before in a linked worksheet so this is an educated guess, but I would check the Page Layout settings for that sheet. On the Sheet tab there is an option to print row & column headings; see if it is checked for that sheet.

[anteagles20]

Yes that has solved it. Thanks!

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

Never mind, already marked! Thanks ....