I am a Macbook user using Excel for Mac as part of the Microsoft office software. I am trying to upload data from an online published dataset saved as "dataset.csv" and want to upload this data to the data editor that i downloaded from statplanet plus. I cleared the data on the data editor, allowed macros, edited the links to update when I changed them on the excel file. My first problem was when I clicked Import data I received a Run Time Error 1004 stating " DataFile = Application.GetOpenFilename("All files (*.*), *.*", , "Please select a file to import")" . I changed this to "datafile=application.getopenfilename()" and then tried importing the data again. However, now, it loads a little bit and says Run Time Error 1004 "excel cannot find the matching data to replace. no cell in the selection contains what you typed, or no records match the criteria". The debugger brings me to this code "ActiveWorkbook.Close savechanges:=False" and I do not know what to do here. Please help in any way. The dataset that we have lists the states, the year, and the number of cases of a disease in three columns. thanks so much.