I have a list in Sharepoint, and I export it to Excel. All fields get exported, so evetything is fine. Then I deside that I for example no longer want the "Modified by" field in the excel file, and I remove it from the Excel file. So next time I do the Refresh, I get all the field, but not the "Modified by". So, just as I wanted. I now have the "Modified by" in my view, but not in my Excel.
Then I change my mind: Now I want my "Modified by" back in my Excel file! I have lots of formatting and macros in my Excel, so I do not want do a new export. How can I do this without removing and re-adding the "Modified by" field in the Sharepoint view?