Hi,

I recently started working on a new MacBook from my old MacBook (i.e. I transferred all files, and am now using the new MacBook, Stata 12 on both devices). The Do-files were working perfectly fine on my old Mac, and are also working fine on my new Mac. However, one of my Do-files start with importing an Excel file. When I move the Excel file in question from my old Mac to my new one, and I do not open the file in Microsoft Excel (2016) first, the Excel file can be imported and the Do-file works perfectly fine. However, when I first open the file on my new Mac (regardless of whether I make any changes) I would get the following error:
Code:
. * Import Data:
. import excel "/Users/Rob/Documents/PhD Exercise Science/3. Data/Data_list_statalist.xlsx", sheet("All_data") clear
file /Users/Rob/Documents/PhD Exercise Science/3. Data/Data_list_statalist.xlsx could not be loaded
r(603);
I have attached the excel spreadsheet that is not working (i.e. after I opened and saved it on my new MacBook).

Can anyone reproduce this error, and is there a solution?

Another piece of information that may be important is that on my Old Mac I used MS Word 2011, and on my new Mac I use MS Word 365 (2019?).

Thanks so much.