TabellenFaktura for Excel · Manual
Solving Common Problems
The most common causes of setup, billing and shipping with the appropriate next step.
The tab "e-invoice, missing
- Check if Excel is open as a normal desktop application and in the Windows account of the installation.
- Close and reopen Excel after saving.
- The File → Options → Add-ins search for TabellenFaktura. COM-Add-ins → Go... The
- Is the add-in below Disabled elements check the reason and activate the trusted installed add-in if necessary. Clear company requirements with IT.
- If again failed, contact the support with Excel version, 32/64 bit specification and error message.
Enable any macros does not fix a missing COM-Add-in.
Unlocking not possible
Check complete personal code, internet connection and correct system time. If you have a device connection message, check the PC change Do not include a license code in a public support image.
Positions missing or too many are recognized
Check the correct invoice sheet, first and last position line or range and all column assignments. After added rows, a fixed range can be too short. Transfers, subtotals and repeated headings may not become additional performances. Check the zero quantity option and the assignment of text extensions and search for the last Excel position in the recognized list. If uniform performances are performed, an explicitly selected fixed unit is possible; mixed units need the correct column assignment.
The sums are not right
Check in this order: complete items, net individual prices instead of gross prices, quantity, correct tax groups, formulas and real rounding, discount/addition and amounts already paid. Excluding double deductions in case of deductions. Distinguishing the amount of invoice, open amount and current payment. Total net and Net invoice after surcharges/decreases must refer to different Excel totals when such charges or allowances apply. Check the tax groups and payment details for each individual amount. An arbitrary cent adjustment is no substitute for a correct calculation.
A visible value is reported as missing
A value in an image, in the print foot or on another sheet is not automatically assigned. Check the cell reference displayed in the field. Record a connected cell via its left upper cell. After a layout change, the value is re-used Select from Excel then save mapping and mappe.
The invoice number is already issued
Search for the number in the journal. If the reservation is part of the current invoice, continue working with this process. If the invoice is already finally created, open the existing file or create a suitable correction. Use a new number for a new invoice. Do not reset the journal to bypass the duvet check.
No Outlook account or draft
Open the classic Outlook-desktop app and check if the desired account is set up and usable. Then in the email settings Reload Accounts select and save the account. New Outlook, Outlook in the browser and other mail programs do not replace the classic Outlook connection. The finished invoice file can still be attached manually.
Missing or duplicate signature: check selected account and signature selection; do not copy a second signature to the message template. In the draft, check recipients and actual attachments.
PDF preview empty or pages missing
If the integrated PDF display is missing, the finished PDF opens externally and WebView 2 is checked on the PC. If the invoice pages are cut or missing, correct the Excel print range, scale and page breaks and re-create the invoice in a controlled manner. Do not repair the PDF by reprinting it.
Archive file moved or not found
The journal knows the original file path. Open File If necessary, you can search for the unchanged file at the new location; a modified replacement file is not accepted as original. If no unchanged copy is present, check a suitable backup. A journal entry does not automatically contain the entire PDF.
Window cut or unfavorably large
Zoom in and use existing scrollbars. After changing the monitor, the window will help Help → Reset Window Sizes. Do not miss out on the invoice just because it is missing in the visible section.
Understanding and passing on test report
Read the understandable message and the copyable test report. Check the named field, cell reference or position line. Correct a missing or invalid date at the source. If the seller identification is missing, assign USt-IdN, seller identification or register identification. Technical details help the support, but do not replace the correction of the information.
After changes, check again. Internal pre-checking and technical testing of the finished PDF or XML are separate steps. Only pass a successfully completed result.
The PDF/A check reports an error
TabellenFaktura 1.6.17 prepares problematic PDF image attributes for PDF/A and can embed certain missing TrueType fonts using an unambiguously matching original font that permits embedding. Unknown or incompatible fonts are not replaced arbitrarily.
Read the rule reference and explanation in the validation report. For font errors, check the font used in Excel, including the correct style, and have your IT team provide it if necessary. If an error persists, send the full validation report and a suitable sample file to support. Only send an output that has passed validation.
Stand by for a support request
- TabellenFaktura version from Help → Info, Windows and Excel versions.
- The concrete step and the full text of the notification.
- A well-readable screenshot without activation code and without unnecessary customer data.
- If necessary, an anonymized copy of the template, whose cell structure and formulae are unchanged.