Good Morning,
I exported the contents of a SharePoint list to an Excel worksheet; however, I noticed the colors and formatting that have been applied to the data. This was done automatically as a part of the import process. I want to make changes to the worksheet’s formatting using a Macro without Excel severing the connection to the SharePoint list when I save it. Will that be possible? If so, can you please spell out in step by step detail what I need to do to make this happen? Thank you in advance.
Regards.