Excel spread sheet into Publisher

Question

_{Thursday, November 3, 2016 8:14 PM}

I am trying to convert a excel spread sheet into Publisher 2016, i have watch a number of tutorials and it seems fairly easy or should be, but publisher stops responding when it gets to the merging stage. I have tried a number of ways, making the spreadsheet smaller doesn't make any difference. is there anyone out there with any idea's or is it just that publisher can't handle it.

All replies (1)

_{Sunday, November 6, 2016 12:28 PM}

Hi,

Based on your description, you want to import Excel Worksheets into Publisher but failed. Did you get any error messages?

Please follow these steps first and check the result:

The ability to import Excel spreadsheets into Publisher makes it easy to bring existing data into a Publisher document. To begin, go to Publisher and click on the "Insert" tab to get to the "Insert" ribbon where you will find the "Insert Object" icon.

Now, click the "Insert Object" icon and you will see the "Insert Object" dialog open. This is where we will import the spreadsheet into your publisher document. In the "Object Type" window, scroll down until you see "Microsoft Excel Worksheet" and highlight that line.

Next, look over to the left of this window: you can choose to create a brand new Excel document if you want to, or you can create your object from your existing spreadsheet. In this case, you want to use the spreadsheet created early, so click the "Create from File." You will now see your "Insert Object" window change.

Here you see the "Browse" button that you will click to locate the Excel spreadsheet you wish to import. You also see a "Link" check box. If you want to make sure that your Publisher document always has the latest data from your spreadsheet, click "Link."

Please refer to my steps and confirm if your steps correct to import Excel to Publisher.

Any updates please let me know, I'm glad to help you.

Regards,
Emi Zhang
TechNet Community Support

Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact [email protected].