Excel Hidden Data

If you try to download an Excel file from Harmony and you get a blank spreadsheet, take the following steps in Excel

 

  1. Select “Enable Editing”on the spreadsheet.

 

  1. Select all rows and columns by clicking the arrow in the top left corner of the spreadsheet.

 

  1. Select “Format”, “Hide & Unhide”, “Unhide Columns”.

 

  1. Once this is complete, you will see the data downloaded from the API.