T: +353 (0)86 3896769 | E: [email protected]
  • facebook
  • linkedin
  • Home
  • Contact

Buchanan Solutions

Web Design, SEO and online systems

  • About
  • Services
    • Web Design
      • Web Design
      • Ecommerce
      • Responsive Websites
      • Multilingual Websites
      • Content Management Systems
      • Domains, Email & Hosting
      • Web Development
    • Web Marketing
      • Web Marketing
      • PPC advertising – Google Adwords
      • Pay per Click advertising – Facebook Ads
    • Web Maintenance
      • Web Maintenance
      • WordPress Maintenance Service
  • Projects
  • Blog
  • Support
    • Knowledgebase
    • Support Enquiry
  • Contact
You are here: Home / FAQs / Blank Excel file when downloaded from website

Blank Excel file when downloaded from website

August 11, 2016 by Keith Buchanan

Recently a few clients found that excel files that were dynamically created online and being downloaded to Microsoft Excel 2015 were opening blank.

Excel files xls / xlxs blank

I tried to change the content type on the download and also change file extension to xlsx form xls but neither worked

Trust Issue in Microsoft Excel

It looked like the file was actually blank but it is actually a trust issue in Microsoft and we were able to get around it by doing the following:

  1. Open Excel Go to File Options
  2. Click Trust Center -> Trust Center Settings
  3. Go to Protected View. there are 3 options that show that were all clicked. Uncheck the first option that reads — “Enable Protected View for files originating from the Internet”.
    In some cases both the 1st and 2nd options need to be unchecked

I had originally thought that I was going to have to rescript the downloads from Excel version to csv but thankfully the above worked.


Category: General

← Support

Services

  • Web Design
  • Web Maintenance
  • Web Marketing

Latest from the Blog

  • Find the Right Keywords for your Website August 22, 2017
  • WordPress 4.8 is out and includes widget improvements July 20, 2017
  • Get your website on Google My Business and Google Maps July 10, 2017
Keith’s work is always very clean, professional and up to date with modern styles. He is always very helpful whatever the query and extremely knowledgeable in his field. He understands the brief and delivers every time
Orla Kelleher
O'Flynn Group

Services

  • Web Design
  • Web Maintenance
  • Web Marketing

Follow Buchanan Solutions

  • facebook
  • linkedin

Latest from the Blog

Find the Right Keywords for your Website

I'm asked many times about keywords, how to research them, ...
Read More

WordPress 4.8 is out and includes widget improvements

WordPress 4.8, the new version New features in WordPress 4.8, ...
Read More

Quick LInks

  • About
  • Blog
  • Projects
  • Contact

Copyright © 2018 · Buchanan Solutions