Using Extract to Excel via .XLS

Overview

Updated 03/03/2022

Microsoft recently made an update regarding how they allow users to open HTML or XLA with an .XLS file.

"The Excel team has made a change in the behavior of certain file types to increase security. This change came in the security updates KB3115262, KB3170008, and KB3115322.  Previously, when you tried to open an HTML or XLA file with an .XLS file extension from an untrusted location, Excel would warn about the mismatch between the file extension and content, but would still open the workbook without Protected View security.

After the security updates Excel no longer will open the workbook because these files are not compatible with Protected View and there is no warning or other indication it was not opened. We apologize that Excel is showing a blank screen instead of a more helpful error message with information about what to do next."

Given this change we suggest the following steps to continue extracting files from within Avionté:

1. Select the file to wish to extract
2. Either from your downloads bar  you can either click the down arrow to the right of the file and select "Open in New Folder". (You can also go to your download folder and right click on the file to select "Open in New Folder"
3. Right click on the file, select properties
4. On the bottom of the popup is an ‘unblock’ checkbox. Check it, click apply, then click done
5. Double click the file to open

**If it still does not open, you can open Excel and then drag the file into the Excel window**

Activate Extract to Excel in User Account

In order to extract searches to excel, the Avionté system admin needs to grant that user access.

Job Board – Extract to Excel

When you are on the job board you can use the Job Finder to sort your jobs. For example, you can select the type of job you are looking for: Contract, Contract to Hire, Permanent or All.  Then add a title such as Java Developer. You can also see the jobs that you are an owner of. Once you click submit, your results will return your search criteria. From there you can extract that list from the right hand corner.

Applicant Tracking – Extract to Excel

Once you conduct a search within the Applicant Tracking, you can go to the bottom of the page and click Extract to Excel. You can also now make the page have up to 200 candidates per page on your results, therefore, allowing for a larger extract.