On this page
Imports & validation
My spreadsheet template is locked or will not accept pasted values
Start with a fresh E-File Magic template for the correct tax year. Current download templates do not require a worksheet-unlock password.
Updated
Use a current copy
- Download the template for the form and tax year you need from the current import guidance. Keep your original workbook as a backup.
- Copy the data into the appropriate entry cells. Keep the template’s headings and structure intact. Do not copy old headings over the new ones.
- Check dates, identifiers and amounts after pasting. If a cell changed meaning, correct it from your source records before uploading.
- Upload the workbook and review the filer, year, form types and sample rows before launching the import.
Identify where the password request appears
A password needed to open an encrypted workbook is different from an Excel worksheet-protection message or your E-File Magic sign-in password. Do not put your account password into spreadsheet cells.
If a fresh template is still blocked, tell support which template and Excel version you use, whether the problem occurs while opening or pasting, and the exact message. Use a blank example when possible. Do not send the completed workbook through ordinary email.
If an import has already run
Check Import History and the saved recipients first. Replacing a workbook on your computer does not replace imported records. Ordinary imports can add records, so avoid repeated uploads while trying to fix a paste problem.