Solved

Open .xlsx files automatically on Mac using Safari

Posted on 2014-02-10
2
5,214 Views
Last Modified: 2014-03-25
We have a simple Intranet with lots of .xlsx files (basically a file server but users access via links).  I know, it's a horrible design but the CFO demands we keep it in place.  In the past, he was using Windows and when he clicked on the link, it would automatically open the file.  Now he has a Mac and when he clicks on the link, it downloads to a folder (and he has to manually go into that folder and open the file).  I know this is by design (Safari safe list) but is there a way around it?  I read something about adding a .plist file into the preferences folder but that didn't work for me.  Any ideas?  Thanks in advance!
0
Comment
Question by:vianceadmin
  • 2
2 Comments
 
LVL 39

Accepted Solution

by:
Eoin OSullivan earned 500 total points
ID: 39847946
What plist file did you edit?  
Was it the "com.apple.DownloadAssessment.plist" file in the User's Library/Preference folder?

As far as I know .. xls, doc and ppt work but the newer xlsx, docx and pptx do not even if you add them to this plist file.  The problem is that Safari does not properly identify the filetype and therefore will not pass it to Excel.

There used to be a way using the RCDefaultApp System Preference to 'help' Safari identify certain filetypes but I've never tested it with xlsx files
http://www.tikirobot.net/wp/2006/12/03/automatically-opening-your-own-downloaded-files-with-safari/

The only solution I can offer is to switch to Firefox which allows you to set an Application associated with any downloaded file and open it automatically
https://support.mozilla.org/en-US/kb/change-firefox-behavior-when-open-file#w_adding-download-actions

If you have all these files linked on your web server you may be able to edit the settings on your Server for mime types to "fool" safari into thinking XLSX files are XLS files.
0
 
LVL 39

Expert Comment

by:Eoin OSullivan
ID: 39847966
If you're using Apache as the web server ... the config file under mime types should have the following line
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet       xlsx

if you change it to
application/vnd.ms-excel xlsx


This will identify the new xlsx files as standard XLS files and Safari "should" allow you to open them in Excel again.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will cover some tips for successfully installing the new update to OS X; 10.5.7. Although the information contained within could be used for any OS X point release.  Please note that this information applies to point releases to a parti…
In this article we have discussed about the OS X EI Capitan and how to fix Wi-Fi issue in OS X El Capitan. We have explained how to delete system level preferences and create a new Wi-Fi location to resolve Wi-Fi issue.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now