Solved

Open .xlsx files automatically on Mac using Safari

Posted on 2014-02-10
2
5,727 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 40

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 40

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Deploystudio is a system which can be used to deploy OSX clients and servers within the small/medium or large business environments. The system is built ontop of the OSX Server NetBoot system and uses images & workflows as its core assets. Although …
Syslogd is a utility that traps and logs messages sent by running processes. It is configured with the syslog.conf file, which consists of lines containing a pair of fields: "the selector field which specifies the types of messages and priorities to…
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 …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

737 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