Property Management, Tenant Selection, Real Estate News & Tips

Update: Export to Excel (Fix to Microsoft Bug)

By on September 8, 2016 in Product Updates with 0 Comments

export-to-excelYou might recall a few weeks ago where Microsoft released an un-announced “upgrade” to Office 365 that broke everybody’s download into excel functionality?

This Microsoft update didn’t just affect Rentec subscribers, it affected hundreds of thousands of people across the web.

While Microsoft is taking their time fixing their ill-fated upgrade, we created a permanent workaround on this side which will make your exporting to Excel (or chosen spreadsheet application) much easier overall.

Next time you login and view a report you will notice two options for exporting to Excel.  The previous option (far right), which Office 365 has challenges opening, is marked with a red asterisk.  If you rely on these formatted Excel reports and have already done the workarounds suggested in this article, you can continue using this red asterisk report.

The new export to Excel option is just to the right of the ‘export to PDF’ option.  Unlike the previous version, the new one strips out all formatting and outputs only raw data so you get a clean, un-formatted, excel output.  While we all loved the formatted output from the previous version, this new version is actually much more usable data when using it in Excel.  Your CPA and other business partners will appreciate the raw data format as well.

While the feature is labelled ‘Export to Excel’, any spreadsheet application will happily accept this data.  This includes Google Sheets (our favorite), Open Office, and Libre Office.

Pro Tip:  Microsoft Excel does not automatically wrap text if you have multiple lines of data in one cell.  Reports that includes multiple lines of data (addresses for example), will by default only show the first line of data in Excel as a result.  To fix this, press CTRL-A to select all cells in your spreadsheet, right click and choose ‘Format Cells”.  Now click the ‘Alignment’ tab, and under the ‘Text Control’ section, checkmark the ‘Wrap text’ option.  Click OK and you are good to go.

Tags: ,

About the Author

About the Author: Nathan is the founder of Rentec Direct and has been pushing buttons at Rentec since 2008 when the first of many servers drew the very first kilowatt of power from the grid. He has a passion for application security and spends an incredible amount of time ensuring your data is protected. When Nathan is not day-dreaming about 1's and 0's, you may also find him "tuning" the development schedule to get that next big feature in your hands sooner or enjoying a ski day at Mt Bachelor! .


If you enjoyed this article, subscribe now to receive more just like it.

Post a Comment