Solved

Open .xlsx files automatically on Mac using Safari

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 …
The /etc/authorization file in Mac OS X 10.x can be used to control access to the various panes of the System Preferences amongst other things. It’s used by some of us Mac Sys Admin’s to give Standard Users access to System Prefs panes that only adm…
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 …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

734 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