Solved

Open .xlsx files automatically on Mac using Safari

Posted on 2014-02-10
2
5,029 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Do you come here a lot? Are you lazy like me and don't want to go through the "trouble" of having to click your Dock's Safari icon and then having to click your Experts Exchange Favorites bookmark to get here? Well then this article is for you.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

19 Experts available now in Live!

Get 1:1 Help Now