PlanMaker #NAME?: Check the Referenced Name

Scope: FreeOffice PlanMaker 2024 desktop, English official manual checked October 21, 2026. Translated labels may differ. No PlanMaker execution or screenshot was performed. Expected results combine documented error rules with independently checked arithmetic; they are not native test observations. Use a disposable workbook.

Use PlanMaker’s own error distinction

The FreeOffice 2024 error reference assigns #NAME? to a nonexistent sheet or range name. It separately associates unknown function names, unmatched parentheses and wrong argument counts with #NULL!. Do not import another spreadsheet’s error-label rules and assume a misspelled function must produce #NAME? here.

Start with the exact formula, not just the visible error. Identify which tokens are sheet or range names and compare them with the workbook’s intended structure. A familiar-looking word is not proof that a named range exists.

Isolate a missing range name

In a new disposable workbook, put 25 in B2 and 3 in C2. Assume this workbook has no named range called UnitCostMissing. Enter =UnitCostMissing*C2 in D2. Under the documented invalid-name rule, the expected result is #NAME? because the first operand does not identify an existing range.

For this exercise the intended unit cost is B2. Replace D2 with =B2*C2. Expect 75. Change B2 to 30 and expect 90; then change C2 to 0 and expect 0. These controls verify that the corrected formula follows both inputs rather than merely displaying a memorized answer.

The repair does not require defining a name. In a real workbook, either restore the intended name and its correct target or deliberately replace it with a verified reference. Do not create a new name pointing at an arbitrary cell solely to remove the message.

Check meaning after spelling

Ask whether the name was removed, copied from another workbook, or meant to refer to a sheet that is absent. Compare the referenced range’s row labels and units with the calculation. Repairing the spelling while pointing at the wrong quantity is still a calculation defect.

If the offending token is actually a function, inspect syntax and documented availability instead. A function copied from another program may need a different implementation; it is not evidence that a paid upgrade is required or that a free equivalent exists.

This is manual inspection. The FreeOffice error-reference page warns that its linked formula Traces tool is not included in FreeOffice. Use the troubleshooting entry point for broader import or recalculation issues and the version guide before following instructions written for a paid PlanMaker edition.

Return to the SoftMaker PlanMaker error selector.