Forum Discussion
GemGem
Jan 07, 2022Copper Contributor
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 previ...
SergeiBaklan
Jan 07, 2022Diamond Contributor
If you open that Excel file, on ribbon Formulas -> Name Manager do you see only one name (or 6) ?
GemGem
Jan 10, 2022Copper Contributor
SergeiBaklan I don't see any and it only says Workbook, not Table so I wonder if I haven't converted it correctly?
- SergeiBaklanJan 10, 2022Diamond Contributor
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?
- GemGemJan 10, 2022Copper ContributorIt wasn't working because I had the filters on. As soon as I removed them the table worked. Thanks
- SergeiBaklanJan 10, 2022Diamond Contributor
GemGem , great to know, thank you for the update