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

  • WordPress Ecommerce Tutorials December 2, 2020
  • Building with Elementor – Tutorials December 2, 2020
  • Using the WordPress Block Editor (Gutenberg) May 13, 2020
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

WordPress Ecommerce Tutorials

Woocommerce is the go to solution for ecommerce websites using ...
Read More

Building with Elementor – Tutorials

Elementor is a great tool for building pages using a ...
Read More

Quick LInks

  • About
  • Blog
  • Projects
  • Contact
  • Privacy Policy

Copyright © 2023 · Buchanan Solutions