MM won't open Excel sheet

[kbtoreador]

I've used MM quite a bit, but for some reason, as I'm trying to create
labels, it stops after allowing be to selcet my recipient list and does not
give me the next window. Instead, it gives me a 'Select Table' Menu, only
there isn't anything to select. Usually it goes right on through so I can
complete the steps, but I can figure out what is wrong with my Excel document
where it won't allow me to complete this mail merge. Any ides?

 

[Peter Jamieson]

Which version of Word/Excel?

If the "bad" workbook is simple enough (e.g. no formulas, just data, try
exporting the sheet(s) to .csv format and importing them into a completely
new workbook.

Does the Select Table menu have an options button where you can check 4
boxes, and if you do, do you then see any tables? Are they the ones you
expect? Can you connect to them?

Have you done anything like use the data menu to make a list or a database
in your workbook?

 

[kbtoreador]

I put it in a new document, and it seems to be working.