Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Errors can occur when importing timesheets due to data issues. The most common data issues are:

  • Incorrect date format

  • Blank active cells

Below are details on how to check if an error is due to one of these data issues and how to fix it.

...

  • Open the Excel file

  • Press Ctrl + End to locate the last active cellcell 

...

...

If the highlighted cell is blank, you will need to clear the blank active cells. To do this:

  • Highlight all blank Row(s)/Column(s) between the last Row/Column with data and the last active cell

  • Right Click and select Delete

  • Save the file

  • Redo Ctrl + End to make sure the highlighted cell has data

    Image RemovedImage Added
  • Re-import the file into FastTrack

...