Ok, so I have a massive Excel Spreadsheet with some lookups and calculated fields. I need to port this over to a SharePoint list.
I'm guessing for something like this the Import Spreadsheet function won't cut it.. and that I have to rebuild the spreadsheet essentially from scratch and start from there.
Is this the case?
Once I create the columns as I want them, can I still port over the information (data) in the spreadsheet or am I essentially pooched when it comes to porting that data over?
View Complete Post