If the template you downloaded does not work properly, please check the following:<\/p>\n\n\n\n
For faster download the templates are sent in a compressed format (.zip files). You must extract the zip file before using the template.<\/p>\n\n\n\n
To unzip the file: Right click on the zip file and select \u201cExtract All\u2026.\u201d You will see a message that will ask you where you want to save the extracted files.<\/p>\n<\/div><\/details><\/div>\n\n\n\n
Make sure you do not leave any empty row<\/strong> on any table: Check each Excel sheet.<\/p>\n<\/div><\/details><\/div>\n\n\n\n 1- Read the \u201cUser Guide\u201d sheet to find out what data to enter and how to enter it. Example of an entry error on Invoice Date: “10\/08\/223” instead of “10\/08\/2023”.<\/p>\n\n\n\n Example of an entry error on Payment Term: \u201c30 days\u201d instead of the number \u201c30\u201d.<\/p>\n\n\n\n If you copy data from another file, special characters or non-printable characters may be present in the data. Dates, for example, will not be recognized as \u201cDate\u201d data by Excel.<\/p>\n\n\n\n If you are importing data from another file, always make sure to paste only the \u201cValues\u201d:<\/p>\n\n\n\n Otherwise, first copy and paste the data into a text editor such as Notepad++, before copying\/pasting it into Excel from Notepad++.<\/p>\n<\/div><\/details><\/div>\n\n\n\n Some data must be unique, one per row. Example: Employee ID, Training ID, Skill Label, Registration Number, etc.<\/p>\n\n\n\n Read the \u201cUser Guide\u201d sheet to find out what data to enter and how to enter it.<\/p>\n<\/div><\/details><\/div>\n\n\n <\/p>\n <\/p>\n <\/p>\n There are formulas on the rows or data tables.<\/p>\n It is necessary that you do not delete all the rows of data tables: Leave at least 1st row then replace sample data with your data.<\/p>\n <\/p>\n<\/div>\n<\/details>\n<\/div>\n <\/p>\n <\/p>\n Make sure the tables contain only your company’s data. Check each Excel sheet.<\/p>\n<\/div>\n<\/details>\n<\/div>\n <\/p>\n <\/p>\n <\/p>\n On the Dashboard, make sure to select the current year on the “Date” slicer. Example, select 2023 if it is 2023.<\/p>\n Make sure that you have previously entered\/imported the data for the year 2023.<\/p>\n <\/p>\n<\/div>\n<\/details>\n<\/div>\n <\/p>\n <\/p>\n <\/p>\n Sometimes users can break analyses, for example by deleting a column or overwriting formulas.<\/p>\n We recommend downloading the file again from your account<\/a>.<\/p>\n As a precaution: When downloading the file, keep one version of the file and work on a copy.<\/p>\n <\/p>\n<\/div>\n<\/details>\n<\/div>\n <\/p>\n <\/p>\n Also, please check that:<\/p>\n <\/p>\n <\/p>\n <\/p>\n The templates work only on Windows PC, they do not work on MAC.<\/p>\n <\/p>\n<\/div>\n<\/details>\n<\/div>\n <\/p>\n <\/p>\n <\/p>\n \ud83d\udc49\ud83c\udffc Watch this video<\/a> to find out if your Excel version includes the Power Pivot add-in.<\/p>\n <\/p>\n<\/div>\n<\/details>\n<\/div>\n <\/p>\n <\/p>\n <\/p>\n 1- In Windows Explorer: right-click the template file, choose \u201cProperties\u201d then check “Unblock” checkbox. <\/p>\n<\/div>\n<\/details>\n<\/div>\n <\/p>\n <\/p>\n <\/p>\n If, despite everything, you are unable to get the downloaded product to work, please email us<\/a> the file and describe the difficulties encountered.<\/p>\n <\/p>\n<\/blockquote>\n <\/p>\n <\/p>\n <\/p>\n <\/p>","protected":false},"excerpt":{"rendered":" If the template you downloaded does not work properly, please check the following: You deleted all rows of a data table before entering your…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/fullwidth.php","meta":{"footnotes":""},"class_list":["post-3694","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\tThere is missing data<\/summary>
2- Use table’s AutoFilter to filter your data and check if there is missing ones. Example: filter the \u201cStart Date\u201d column to check if there is (empty) Start Dates.
3- Enter the missing data.<\/p>\n<\/div><\/details><\/div>\n\n\n\nThere are data entry errors<\/summary>
There are duplicates<\/summary>
You deleted all rows of a data table before entering your data<\/summary>\n
You left the template sample data<\/summary>\n
You have not selected the current year on the Dashboard<\/summary>\n
You have made changes that cause malfunctions<\/summary>\n
You are using a Windows PC, not a MAC<\/summary>\n
You are using Microsoft Excel 2016 or higher with Power Pivot add-in<\/summary>\n
You have enabled Macros<\/summary>\n
2- Then, when opening the Excel file, Activate the content: Click on “Enable Content” button.<\/p>\n\n