Forum Discussion
Format as table to use in a List not working
I'm trying to create an MS List with a calendar view and I've got an Excel spreadsheet with the data because that's the only way I can think to get recurring events (ie use different lines then previous date +7) but when I "format as table" as recommended in the instructions although it looks right, Lists thinks there's 6 different tables. I even named the table in Excel but Lists doesn't see that. Any ideas? It's only one tab.
5 Replies
If you open that Excel file, on ribbon Formulas -> Name Manager do you see only one name (or 6) ?
SergeiBaklan I don't see any and it only says Workbook, not Table so I wonder if I haven't converted it correctly?
It looks like you have the Table named _2022. With Microsoft Lists -> New List -> From Excel -> Upload your file
it shall be one list taken from above table. Or you do that in different way?
