This section provides a new User with tips on how to get started using the Wizard.
1. Enable Macros – The worksheet requires the macros to be enabled.
When the worksheet is first opened on the menu bar the following will appear. Click on the Options button, click ‘Enable this content’ then Ok.
2. Unable to see Wizard Ribbons - If this occurs then your security settings are too high. Employee Wizard is written in VBA, and you must allow macros to run before you can run the program. Close the worksheet then from the Excel menu navigate to the following based on your version of Microsoft:
Navigate to the ‘DEVELOPER’ tab in the ‘Code’ group and click ‘Macro Security’. In ‘Macro Settings’, select the ‘Disable all macros with notification’. Reopen the worksheet and you should receive the message shown above.
Note: If the DEVELOPER tab did not display, click the Microsoft Office button 
, then click ‘Excel Options’ button. In the ‘Popular’ category, select ‘Show Developer tab in the Toolbar’. You should now be able to go back to the DEVELOPER tab to make the security changes.
3. Wizard Ribbons – Please see the note below for details on the Ribbons provided by the Wizard.
4. Row 9 - The column names are stored in row 9. This is fixed and cannot be changed. Do NOT insert or delete rows before row 10. The case of the column names is not important but spelling is. If you change the column name in row 9, you have in effect deleted the column as far as the program is concerned. You can move the columns anywhere you like, hide, or even delete them if they are not required.
5. Row 10 - This row is used to enter Default Values. Any data here will be defaulted into the same record where no data exists in the worksheet.
6. Populate the Worksheet - There are a number of options available to populate the worksheet:
• You can type or paste the relevant values directly into the worksheet (No validation is performed until you run the upload program).
• You can use the data entry forms provided to enter and validate the values.
• You can download existing data and modify the information to update the record
OR
You can download existing data and use this as the starting point to create new records. Note if you are downloading an existing record to create a new one you need to remove the ids of the existing records.
Note: This Wizard provides users with a huge amount of functionality and power to make changes on mass. The complexity and nature of Oracle Human Resources means that you need to be very careful about the update modes and effective dates that you use. Despite every effort being made to test this product thoroughly during development, it is imperative that you do comprehensive testing in your test environment prior to making changes in production.
