Cannot open Excel file exported via Report export after Microsoft Office update on July 12th 2016

Cannot open Excel file exported via Report export after Microsoft Office update on July 12th 2016

Analytics

Last updated 2017-04-14 ·Reference W-3236574 ·Reported By 1000 users

Fixed - Summer '16 Patch 16.0

Summary
On July 12th, 2016, Microsoft released a security update for Office which caused files downloaded from several websites (including Salesforce) to generate errors when opened.

Impact to Salesforce files
Salesforce files downloaded via "Printable View" and "Export Details" generate a "file is corrupt and cannot be opened" error when opened.

Microsoft has released a patch to fix the problem for "Export Details" (download Microsoft's software patch here: https://support.microsoft.com/en-us/kb/3181507 ), but "Printable View" exports are still subject to the error. We're continuing to work with Microsoft to correct that issue.
Please see related Known Issue linked below for updates to the issue with Printable View:
https://success.salesforce.com/issues_view?id=a1p3A0000008fbH

Repro
After applying the MS Office update from Microsoft:
Microsoft Security Bulletin MS16-088 - Critical
Security Update for Microsoft Office (3170008)
Published: July 12, 2016
https://technet.microsoft.com/library/security/MS16-088

1. Create a report and export it as "Printable View" or "Export Details"
2. Open the report by Excel on Windows.
3. Excel will show empty content.

Workaround
Fix "Export Details" file access errors
To open files created via Export Details, install Microsoft's latest Office update (download Microsoft's software patch here: https://support.microsoft.com/en-us/kb/3181507 ). If you're unable to install the patch at this time, try one of the workarounds listed later in this article.

Fix "Printable View" file access errors
Even with Microsoft's latest Office software patch, files exported via "Printable View" still generate the error.
The only current workaround is export via "Export Details" and use the solutions or workarounds offered for that export method in this article. Please see related Known Issue linked below for updates to the issue with Printable View:
https://success.salesforce.com/issues_view?id=a1p3A0000008fbH

Workarounds for "Export Details" if you're unable to install Microsoft's latest Office software patch:
​We have identified four workarounds as options for opening exported reports in Excel until you are able to install the Microsoft patch linked above.

Keep in mind, Salesforce cannot advise on the settings or applied patches for Microsoft products. Please work with your internal IT department to determine the best course of action for users within your organization.

Change the export file format to "Comma Delimited .csv"
Note: Exported .csv files do not contain the formatting found in .xls files. Please review your exported file to ensure it meets your needs.
1. Run your report.
2. Click Export Details.
3. Change the export file format to Comma Delimited .csv.
4. Click Export.

Unblock access in File Properties
1. Right click on the file, select Properties.
2. On the General tab, click Unblock.
3. Click OK.

Disable the Protected View setting within Excel
1. Open Microsoft Excel.
2. Select File | Options.
3. From the menu on the left, click Trust Center.
4. Click the Trust Center Settings button
5. Click Protected View.
6. Deselect Enable Protected View for files originating from the internet.
7. Click OK, then click OK.

Remove this specific Microsoft update from the local computer
If none of these workarounds work for you, you can uninstall the original patch which caused the issue as a last resort. If you have questions about how to remove the patch, please consult Microsoft's support.

Reported By (1000)

Marissa Telfer Rebecca Ralls Bhargavi Kaipa Daphne Robinson Yvonne Cunningham Rafael Balconi Lesley Paniszczyn Patresha Strom Juliet Martin Heather Fisher Jason Morrissey Christina Gonzales Marshall Henry Sujit Mandal Fay Rogers Goettsche Dan Underwood Daren Forster Brittany Bond ITSM Admin John Mitchell Trinh Harrison Lauren Tudor Sunil Sarilla System Administrator Jon Neustedter Leon Houseman Madar Laffir MICHAEL ARNDT Tanis Irwin Pavan Kumar Andrea Aldana Steve Garrett Steven DeMeola Stephen Smith Chad Coleman Megan Brooks Brett Childress Jeremy Entringer Didier Beaufays Christophe Porier Darren Braddock Peter Umali dinesh sivalingam Donna Thomas Daniel White Mia Towndrow Bruna Lanzani Guus van Knippenbergh Atena Kricej Keri-An Richards SY Chan Karen Joy Sarandin Pricing Distribution 真由美 木田 Scott Stith Jamie Bellows Margitta Fulda Amy Botine James Mitchell Mirinda Sandoval Rick Culbreth Jean Velonis Ashley Parker Chris Aubut Sergio E. Rodriguez Randy Perkins Diane Bias Christina Brown Mandy Love Michael Slawnik Admin Admin Amy Wilson Cathy Chapman Emma Vandervest Jaimin Patel BBA CRM Admin Brandon Lang Daniel Blackwell Amy Adams Jess Carosello Ginger User Misty Jones Kyle Atkinson Elizabeth Vleaminck Jerico Paguio Destiny Russo Natalie Battista Stephanie Johnson Lorne Gregory Danielle Pratola Irina Perry Alexis Davis Robert Allen Alan Simpson Kunal Sharma Nate Dissmeyer Elise Dahlin Liz Tupper Price Laurene Demoy Laurie Smith Leela Balgobin Nicole Petsch George Atkins Natasha Marone DAVID GANT Katherine Rowe Bruno Soares Joanne Smolen Jason Lorden David Roberts Sherry Culbertson Mathieu Perrin 和也 常世田 Katsunari Hatakeyama Roey Benami Roey Benami Binoy Sivan Mino Buerge Lyudmila Mukhina Mizota Junko Hong Yik Lim Anvesh Vedula 由衣 山本 David Rego Jeffrey Wong Brenden Wells Sierra Kemp James Tu Gay Thorne Christine Duborg Chad Kobold Tisha Ford Charles Chunn Bob Sorrells Mark Keith Jennifer La Porta Sue Nelson Brad Schernecker jithesh Rao JoAnn Vormschlag-Eckhoff Jean Slusher William McNally Chris Lawless Joseph Hinton Josh Green Michelle Kernohan Aaron Genter Aaron Judkins Heidi Krapfl Patrick Watkins Mark Bourbina Jason Howe Karen Byrum Celina Herrero Bruce Wayne Beth Saunders Troy Ewton David McGruther Dennis Bosman Kate Murphy Detlef Block Maria Belli (DO NOT USE) Srinivasan Santhanam robert Pond Jeremy York Informatica Rose Finelli Nelson Vaz Kathleen Lehnigk Marisa Montanaro Alex Boyce Casey Hayes Jon Parker Matthias Carle Claire Callan Joshua Bond Jess Wilson William Turner Claire Jones Andrew Seditas Swapnil Sakpal Shintaro Hara 春奈 山本 Matthias DE JOUVENCEL Troy Plain Jayadevan Ravindran Divya Gupta Ryo Takahashi Louise OBrien Shubham Shrivastava Ange Sutherland Victor Almeida Ravindra Babu Jürgen Schneider Rhonda Ross Jim Stalder Santosh Swain 翼 生天目 Yasuetsu Ishiguro 石黒 康悦 Mark Deuel Todd Waller ASGadmin George Davis Tintu Babu Immanuel Williams Thomas White Brandon Fishman Naveen Gali Richie Ho Denis BOURDON George CALIŢA Mandy Drew Chun Wei Lee Ginette Lacroix Shilpa Kinkar Lisa Admin CRM Johnathan Tom Brian Pickett Kazuya Tokugawa あい 稲川 陽祐 青木 Hiroki Sato Shigenori Koinuma Gyatri Jay Das 大二郎 神谷 Marco Boerlage Ron Planken 強志 松本 Saskia Koekenbier Pritam Shekhawat Taiki Yoshikawa Roberto Salvatori Alex Wiggins Jason Hutchison Amy Korsi Valerie Brodie Jane Leigh Conrad Jooste Mary Perrotta Rick Copeland Melanie Harmon Kira Tubo Susan Nelson Martin Monkewicz Debbie Burson Marketing Team (QLogitek) 彰 秦野 Brett Thompson Karen Espinosa Kavita Sunderason Colin Johnson Ricardo Nonato Daphne Bunch An-Mei Yi Erika Macaione Holly Lewis John Dean Yvonne Dickinson Andrea Alonso Huerta D2D Administrator Hillary Anderson Amalan Manoharan Traci Kim Derek Wiers Kris Wiley Kris Kelly Matthew Rhine Esti Gershonowitz Anna Summerlin Andrew Miller S C Jerry Edquist Ben Patterson Christina Zuniga Jesse Pedersen Louise Gilmour Kim Hargrove Simone Schmudde Denise Placencia 久美子 中野 真希生 大木 Hatsuo Sano Goshima Itsuko Cat Craven Go Fukumoto Shona Angus Clarinda Dobbelaar Tunde Odutola Ruzica Cubric Angus Lindsay Lindsey Addison OR Systems Lindsay MacArthur Karla Smagorinsky Amanda Watkins Marques Hollie Chip Severn Ramon Del Salto Brian Buckland Ellen Krupp Christy Warren Heeyeon Park Ana Elisa Franco CallMaX Marketing Jess Rudy Wenda McMahan Tina Peck Lopa Pal Tasha Raman Linghao Wang Laurie Johnson Gina DeCola Greg Rohman Nicole Laperouse Claire Randall Mandy Checkai David Hood Debby Agresta-Ungaro Simon Ruzicka 精型 黒田 Midori Yoshino Flora Ng 隆之 久保田 Thibaud Viotte Kirsten de la Haye Dana Yarbrough Sharon Binion Karen O'Neill Michelle Gordon Edward Alexie Gutierrez Alyssa Conary Brent Clark Christy Fulton IT Don Carver Rick Kwong Samantha Price Dave Wolfe Kalyan Pothineni Jennifer Thomas Craig Stoddart Kent Cozad Elizabeth Carlock Nathan Denny Stephanie Foerst Julian Azzam Sarah Rems Terry Holash Chris Dwyer De'Anna Chapin Ellen Scully Joe Blodgett 大 古谷 綾子 鈴木 tomoki okuyama 志乃 石黒 千夏 長嵜 Jason Erickson Christine Reiser Sérgio Durão Sunny Seelam Gordy Drost Elaine Drake Suzanne Lesser Lindsey Acciarito Matthew Soleyn Jeff Baker Amy Cobb John V Usamah Suhrawardy Chris Lance System Admin Alice Dobrow Cynthia Clauss Kathy Frantish Sheryl Eubank Edward Yerke-Robins Corey Schmidt James Calabrese Karla McKenzie Dimitri Mirangi Jayson Irizarry Shannon Simons Brandon Garvin Carrie Molson Tomoya Honda Administrator Arts Law Coral Conrad 保守 システム 尚子 栗山 亮 肥爪 Witarn CHA Emiliya Boiadjieva 真貴子 神谷 Davide Perretta Jonathan Garrison Jean Jaenicke Jeffery Le Blanc Shila Leos Sarah Grover Aron Kuch Carolyn Reilly Kaycee Espe Alicia Studley Thanh-Tung Ho Foziya Doctor Brandon Sowers Fred Flynn Lone Star69 Stacey Fear Donna Lindsay Jeremy Jolley Michael Mazzotta Ian Vassallo Prakash Thyagarajan 滋人 田上 RSI Simon Tanguy Camila Silva Nunes Larry D. Dortch Jaclyn Millan Stephen Athan Maarten van Hulst Jay Mehta Genna Strauss LaFrance Laura Squires Marc Juliano Matt Petersen Andrew Ho Talent Rover Admin Veronique Laville Stuart McKitrick Julie Tenold Tim Smith Richard Houston Molly Smith Kim Wilkins Tonya van Hees Jim Hartman James Anderson Janell Parga Stephen Reiners Tushar Naik Florent GUIGNARD Drew Pulino Samantha Jones Sarah Olague Stewart McNaught Kelly Hanna Debbie Reeves Roger Halverson Steven Dykstra Sheila Baker Cathy Clearman Kyla Longe Tim May Erica Ramey Brian Makas Ewelina Binkowska Yvette Cesar Jessica Brown Jed Cavadas Megan Gammack Manjunath Chandrashekhar 管理者 GSC First Last Wendy Byerly 管理者 システム Jason Ross 総務 経理 Ikou Sanuki 大介 山名 臣生 太田 Yu Yano 業務2 Robyn White システムユーザ 光成 津久井 順子 タム 雄資 大野 Aylin Aslan 美保 古口 James Rogers Jeremy De Lord Kevin Whelan Jake Saul Shanice Chance Wayne Day Jamie Rogers Amy Parslow Chelsea Odegard Troy Morrison Kristen Drigon Micaela Flynn Felix Philip Trudy Oswald Lakeva Morman Mike Schuster Jenelle Kang HANG ZHOU Huma Thekedar Gary Fuller Georgia Papoulias Vincent Lim Peggy Lau Bas Bisseling Eamon Kelly Monica Anderson Shona Stevens Banquet Sales Team Holiday Inn Gent Expo Joseph Tomarchio 英樹 金子 Giuseppe Ciraudo Erin Gilbert Janna McNeil Christie Carpenter Abigail Sanchez Cynthia Hsu William Wharton Trish Strehle Gary Vogt Eric Whitney Adam Lomas Melissa Dahl Brett Collard Erin Boreros Brian Donnelly Takahito Miyamoto Daniel Romero 裕輔 仁田原 美里 藤曲 Jason Sturt Application Support Aleksandra Kowalska 誠 林 一樹 竹田 Roger Farrow Dean De-Viell Ritesh Kotian Chris Goodwin Bianca Pahuta Richard Conley David Gandara Rick Baierlein Sanjay Jhim Erin Madden Ramirez Lauren Bird Brittany Montgomery Hudson Krakowski Diana Mendoza Kyle Floersch Michelle Paul Jill Michaelree Kristin Hubbard Carlos Ortega Debbie Marchand Larry Evans FlightWare John Graf Jessica Rowshandel Chad Merica Atalanta Powell Ryan Rickard Dionne Schweitzer Piya Fiedler Srikanth Muvva Shelly Ryder Jeff Battles Scott Gryder Pat Hunt Chelsea Trinka Zane Ritt CloudSocius Iwan Celissen Tim May Samantha Colbert Evan Ponter Christina King Teresa Stoll Wendy Zangl Sales Operations Aimee Lawrence Kat Sullivan Sue Wright Daniel Cable Paula Goche Navied Sadeghi Arthur Holtz James Cary Rick Wiepking Amanda Graham Keith Ayers Trudi Jackson Stephanie Foerst Stacy Jewell Chris Robinson AmCham Membership Haruna Shigematsu Admin Stephen Cunningham Maureen Bacon Cheryl Harris Kristina Lorenz Chris Minerd Justin Tidwell Ronald Neve Andrea Vince Eva Wright Phillip Le Duq Jones Brittany Bulger Stefan Obst Tess Wendel Neal Hicks Shivani Goel Judith Osnaya Marisa Connell Chandan Grewal Elizabeth Nelson Jeff Karlsson Brandon Carr James Newman Jennifer Bruno Kristen Lund Kris Siewert Steve Gardner 剛 白銀 淳一 石﨑 有加 松田 Sindoora Gopagoni Hanna Perez Santosh Bapat Lynette Holtzhausen Zachary Rigby Jason Foster Sara Levine Ben Beeson John Brazda John Brazda Julie Montagne Hadley Stocker Rupsa Das Vamshi Mucha Jason Davis Kavita Raju Bill Ramsay Anna Calcagno Melissa Shook Kristie Combs Jim Garrison Amy Bucciferro Takashi Fukumoto Mark Lester Cabrera TSC Service Cloud管理者 yoshitomo terakado 寺門 資智 公諸 辛嶋 George T Craig Rowley 営業事務 営業事務 真彦 池村 Ian Templeman Danny James Ian Chapling Henri Volk Girlie Bensali Thomas Sauvage Jill Chiarella Sally Mendonca Anne Watson David Fisher Trevor Serfass James McPike Leo Schafer Mariann Anderson Susan Schofield Krista Miller Christine Chapa Heather Troup Morgan Thomas Carl Lange Craig Revie Laura Smiley Joel Johnson Bob Tolan Nana Gregg Cassandra Dutile Mase Goslin Jessica Wilson Brett Walters Kevin Lepine Amber Bird Ragin Edwards Kyle Broeckel Morgan Collins Kitty Wong Rebecca DiMaggio Kevin Shearer Sharon Sun Nicholas Willard Thomas George Lisa Morris Avalon Lucero Sooryata Preeti Sadeo Vicki Shakespeare Srikanth Challa Petra Cibulkova 海老名 Megha DALMIA Anil-kumar SAMBRANI 裕也 郷右近 Jasleen Kaur MAKKAR Aleph Admin Amanda Biggs Pierre Eymard Migration Admin Yaron Dror Ritchie Scott Will Hartsell Eleanor Matthewman Erin Dederich Kent Moir Lizz Hellinga Melissa Utsett Ken B Andrew Hansen Ann Collins Saffat Jamal Jenna Binder Matt (Tyco SG) Tuomala Carl Ciardelli Heather Schreiber Morgan Turner Laura Holst Zack Steele Chris Rustici Anne Laughlin David Eddison Trisha Sweet Brenda Wheelock Christopher Peotter Joseph Elliot Richard Henrich Paul Retter Heather Wallace Peg Rifleman (old profile) Paula Burgess Mike Hoogervorst Louise Cribbin Rajesh Dhawan Elke Schwarz Vignesh Prabhudoss Angelia Kay Tracy Utterback Colin Graf Andrew Riley Old Account Clark Liddell Jeff Berger Rita Warren Andrew Krisak BIOS Support Admin GreatVines Charline Gaume Stephen Wheeler Monica Johnson Edward Fairburn Admin GreatVines GreatVines Sales Rep Phillip Baracewicz Penelope Chandler Raghavender Pulipati Zvi Eizenberg Casey Meyer Kraig Paxman Stacey Venema Haroon Abbu David Liu Andrea Kozminski Dorothy Luczak Ferrari-Carano GreatVines 愛 鶴久 Kien Hoang 明子 田邉 広美 柴崎 Tom Blamire Applications IT Eagle Street Melvin van Leeuwen Norbert Böck Alan Cole anna zawada Jonathan White Renata Mattson-Drozdowski 優香 山岸 高雄 安藤 Yusuke Nakamoto 喜則 大舘 Kirstin Gleeson Niels Huijzendveld Naresh Koya Kelly Chilton Kim Brussow Freida Lindsey Colleen Graves Steve Garcia Mike Rucci Alyssa Forsberg Casey Scheler Eric Cottone Denise Meikel Brad Venard Jim Radochia Help Desk Jerry Yarnish Steve Birndorf Becki DeRusseau Joe Cornwall Virgil Hu 千晴 義原 Mike Clutts Sabiha Anup מנהל מערכת Ajay Jayswal 有美 川上 LeAnn Hartka Laura Baker Mike Sheehan Crissy Koger Ashok kumar Ramamurthy Myra Wilson Chris Uttley Marian Luisi Travis Levers Kimberly Martin Vicky Parres Michelle Stewart Heather Landgraf Tim Roake Steve Baker Jerry Hopper Tim Horzmann Mike Needham Sherry Cottle BRISEL SARAI DOMINGUEZ SANCHEZ Nagesh Vattikonda Steve Powell Kara Geiger Marcie Fontecchio Adam S Christine Kennedy Joe Adams Jessica Tannenbaum Jen Kerhin Song Vang Matt White Daniela Palomo David Scamporrino Shawn Pearl SFDC Admin 正由 久野木 忠 下之段 管理者 システム 総務 洋範 高良 (公財)ロータリー米山記念奨学会 昌裕 梅本 幸治 島 Bruce MacLennan Cloud Socius Ellen Hindson Chris South Rachel Hands Jude Shimer Josh Hines John Kollmer Meryl Christopher Pratyush Adhwaryu Dale Ziegler Deb Delaney Shana Kargbo Hunter Sabol Jon Schantz Srikanth Matety Cathy Tinsley Autumn Patterson Dianne Tanihara Jeffrey Azevedo Linda McIntosh Ian Brown Peter White Brandon Andrews Kate Moylan Susan Arsenault Tory Pfenninger Michelle Nunnerley Peter Gibs Motive Admin Jeffrey Caplin Rebecca Glasser Melinda Heller Greg Cotton Brooke Haynes Ted Ajmo Gaurav Singh Kathryn Lee Blair Sellke さより 窪野 俊郎 佐木 淳 関口 亜早子 大林 久美 太田 Allan Pearson Dennis Poetsch Louise Lockie Tania Smith Nicole Einsiedel Karey Smith Jayesh Patel Thomas Göcke Kirstin Hyland Sarah Simes Angela DiCesare Alicia Rozeboom Peter Feilberg Mary Lorch Rennie Filler Meria Muthara Marcia Garcia Brenna Hawk Leandro Rodrigo Nunez Eric Kozlowski Emily DePottey Rockfeller Fixe Darcey Johnston Jason Vance Kate Shepherd Lorraine Hennessey Bill MacDonald Tina Hill Elizabeth Rosenberg Rob Brunner Scott Maison 佐和子 岩崎 Pawan Gupta Yoshiko Tsuji Alexandre kurkin Martin P Trudy Knapp-Rhodes Julie Savage Jessica Unkrich Timo Winter Eric Pitts Cheryl Bentley felicia wiggins Keri Humphries Joel Valento Heather Wilkins Jeff Bowman Jaime Stuntz Anthony Zybak Eric Thiem Sysadmin Greg Valure Carly Mandel Haroon Kauser Kevin Stack Adam Rife Nicole Fites Colette Askeland Katie Spanos Zac Owens Mark Buhlman Bronson O'Quinn Katherine Hartman Andy Waugh Dave Cassells King Ho Olaf Habig システム管理者 NSSOL Jarrod Shumaker Maggie Sluka Bertrand Mars ANNIA CARVAJAL Shariq Abbasi John Ramirez Kalen Gary 智仁 井川 Evan Brochu Miranda Wigginton Janelle Mahler Frank Litts Robin McCarthy Rhonda Riley Justin Helgerson Trudy Crawford Ben McCauley Hamish Richardson - G-QUICs_Admin 尚史 大津 Sato Atsushi

Is it Fixed?

AP0 AP3 AP4 AP5 AP6 AP7 AP8 AP9 AP14 AP15 AP20 AP21 AP22 AP28 CS1 CS2 CS3 CS4 CS5 CS6 CS7 CS8 CS9 CS10 CS109 CS108 CS107 CS106 CS105 CS102 CS101 CS100 CS115 CS110 CS11 CS116 CS12 CS137 CS138 CS13 CS14 CS15 CS152 CS151 CS16 CS17 CS18 CS19 CS20 CS21 CS22 CS23 CS24 CS25 CS26 CS27 CS28 CS29 CS30 CS31 CS32 CS33 CS34 CS35 CS36 CS37 CS40 CS41 CS42 CS43 CS44 CS45 CS47 CS50 CS51 CS52 CS53 CS54 CS57 CS58 CS59 CS60 CS61 CS62 CS63 CS64 CS65 CS66 CS67 CS68 CS69 CS70 CS71 CS72 CS73 CS74 CS75 CS76 CS77 CS78 CS79 CS80 CS81 CS82 CS83 CS84 CS85 CS86 CS87 CS88 CS89 CS90 CS91 CS92 CS93 CS94 CS95 CS96 CS97 CS98 CS99 EU7 EU8 EU10 EU12 EU13 EU14 EU15 EU16 EU17 EU18 EU19 EU25 EU26 EU29 EU30 NA104 NA100 NA101 NA103 NA102 NA105 NA129 NA130 NA132 NA131 NA146 NA154 NA155 NA196 NA21 NA32 NA33 NA37 NA39 NA40 NA42 NA44 NA45 NA46 NA47 NA49 NA50 NA51 NA52 NA53 NA54 NA56 NA57 NA58 NA59 NA60 NA61 NA62 NA63 NA64 NA65 NA66 NA67 NA68 NA69 NA70 NA71 NA72 NA73 NA74 NA75 NA76 NA77 NA78 NA79 NA80 NA81 NA82 NA83 NA84 NA85 NA86 NA87 NA88 NA89 NA90 NA91 NA92 NA93 NA94 NA95 NA96 NA97 NA98 NA99 UM1 UM2 UM3 UM4 UM5

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.