Auto refresh Excel worksheet after changed by exteal application?

I have a question similar to this one but I'm just using an Excel file, no CSV involved:

Open a .csv file in Excel and have it update whenever .csv file changes

I have an Excel file that I frequently edit in two ways: 1. manually like most end-users and 2. through an exteal 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? Perhaps some VBA code or plug-in? I find it annoying to close the workbook and open it again with every edit.

Excel for Mac 2011.

Recent Questions...