Excel 2016 file ignoring links and grant access using applescript
<p>The problem i am having is that i am always receiving new spreadsheets and if i run the code below.</p>

<pre><code>set resultWorkBook to "/Users/x/Desktop/myfile.xmls"
tell application "Microsoft Excel"
        set resultWorkbook to open workbook workbook file name posix_file without update links
    end tell
</code></pre>

<p>It will try to open the spreadsheet but then come up with the dialog window asking whether to grant access or not.</p>

<p>If I run the same spreadsheet like this.</p>

<pre><code>tell application "Finder
set filecontents to file of folder Desktop of (path to home folder)
end tell
tell application "Microsoft Excel"
        set display alerts to false
        set resultWorkbook to open filecontents
end tell
</code></pre>

<p>It will open the workbook without asking for access but then comes up asking me to choose one of three options regarding links in the spreadsheet.</p>

<p>I really need the best of both worlds, and wondered if anyone could give me a solution.</p>

<p>Thanks</p>