Knowledge base

Clear answers for your next step.

Back to Support
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

  1. Download the template for the form and tax year you need from the current import guidance. Keep your original workbook as a backup.
  2. 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.
  3. Check dates, identifiers and amounts after pasting. If a cell changed meaning, correct it from your source records before uploading.
  4. 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.

More guidance

Still need help?

Contact our team1-877-836-6680