I have a question similar to this one but I'm just using an Excel file, no CSV involved:
I have an Excel file that I frequently edit in two ways:
- manually like most end-users
- through an external application (R) that edits some of the content.
I switch back and forth between these two methods.
Is there a way to refresh the contents of the worksheet in Excel after R has edited the contents? I find it annoying to close the workbook and open it again with every edit.
Excel for Mac 2011.