Importing data from a “Formatted” spreadsheet will import back into the original aspects and result sets that were contained when the data was previously exported. Importing data from an “Un-formatted” spreadsheet will require user input to map the columns of the spreadsheet to the aspects and result sets in SIMS. If the spreadsheets are exported…
To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…
Before setting the password it is important to remember that if you lose or forget the password, it cannot be recovered. Also remember that passwords are case sensitive. Click the File Button , click Save As, and on the bottom of the Save As dialog, click Tools. On the Tools menu, click General Options. Under File…
Can i set a password on a spreadsheet?