AREKTON

™

Help and troubleshooting

Find a quick answer, follow the steps and check the expected result. If the issue remains, use the Support form at arekton.com/support. Keep a backup before troubleshooting and work on a copy of your project.

These instructions cover the current protected AREKTON workbook and 40-day trial. Windows desktop Microsoft Excel with permitted VBA macros is required. Excel is not included. Excel for the web, mobile Excel and Google Sheets are unsupported; Mac compatibility has not been verified.

Opening your workbook

I downloaded the ZIP but cannot use the workbook

  1. In File Explorer, right-click the downloaded ZIP and choose Extract All. Open the extracted folder.

  2. Read START_HERE.txt and the included PDF guide. Open the .xlsm workbook in desktop Excel, not from inside the ZIP.

  3. Keep the supplied starter untouched. Before entering data or activating the trial, copy it to a writable local project folder outside OneDrive/SharePoint and give the working copy a clear project filename. Keep the .xlsm extension.

Expected result: The extracted folder contains the workbook and instructions. You are working in a separate project copy.

The buttons do not work or Excel says macros are blocked

  1. If Protected View appears for the AREKTON file you intended to open, choose Enable Editing. If a yellow macro warning then appears, choose Enable Content. Enable Editing alone does not enable macros.

  2. If downloaded macros are blocked, close the workbook. Right-click the extracted .xlsm file in File Explorer, choose Properties > General, and select Unblock if available. Click Apply and OK, then reopen the workbook.

  3. If an employer manages your settings, ask IT to approve the file. If antivirus reports an alert, stop and send support the alert details. Do not disable antivirus, enable all macros globally or bypass employer restrictions.

Expected result: The workbook opens without an error and its buttons respond. Customer packages already contain their automation; no VBA imports or add-ins are required.

Excel offers to repair the workbook or shows a compile error

Stop using that copy for billing. Keep the original download and a backup of your project. Report the exact message, workbook filename, Excel version and what you clicked. Do not repeatedly repair and save over your only project copy.

Entering data and saving billing

I cannot type into a cell

  1. Check the tab and column label. Automatic project IDs, calculations, print forms and saved billing areas are locked. Enter data in the source register or intended input field.

  2. On Schedule of Values, column A is the automatic Project ID. Enter the item number in column B. Keep sheet protection enabled.

  3. If all trial input fields are blocked, check Trial Status. An expired trial keeps existing records available but blocks editing and new billing captures.

Expected result: Intended inputs accept entries while calculated cells remain protected. If an intended input is unexpectedly blocked in an active trial or paid copy, report the tab and cell to support.

Save Billing Package says Add at least one SOV line

  1. On Schedule of Values, confirm at least one line has an item number in column B, a work description in D and a scheduled value in E. An entry in column A does not create an item.

  2. Complete the applicable previous work, current work and stored-material entries in F:H. Enter the retainage percentage in L on each populated line; use 0% when zero retainage applies.

  3. On Pay Applications, create one unique application number from 1 to 20 with a period-ending date and Draft status. Keep only one Draft. Select that application on Print Setup B5, complete the required project and billing details, and click Save Billing Package.

Expected result: A valid package reports READY FOR REVIEW on Print Setup B18, with E6 and E7 both zero. If the message remains, retain your entries and send support the exact message and relevant cells; do not type into Billing Capture or Billing Snapshots.

Print Setup says DRAFT CHANGED SAVE PACKAGE AGAIN

The current draft inputs differ from the last saved billing package. Review the changed values. If those changes are intended, click Save Billing Package and approve replacement of that Draft only. If they were accidental, restore the intended inputs and review the status again. Printed payment/SOV output continues to use the saved package until it is deliberately replaced.

Expected result: After a valid deliberate capture, the readiness status returns and the printed package reflects the reviewed values. Submitted, Certified and Paid packages cannot be replaced through Draft capture.

I pressed Ctrl plus S but the printed application did not update

Ctrl+S saves workbook edits. Save Billing Package separately captures the selected Draft and its SOV history. Select the intended Draft on Print Setup B5, review the inputs and click the capture button. Do not copy/paste into the locked billing sheets to force an update.

Importing projects and printing

The import window says Path does not exist

  1. Dismiss the warning. In the output-folder picker, navigate to an existing writable local folder.

  2. Select that folder and choose Select Folder. AREKTON generates the project filename automatically; do not type a workbook filename into the folder field.

  3. If you want a new subfolder, create it in File Explorer first, then select it in the picker. Use a local folder outside OneDrive/SharePoint for the import.

Expected result: After selecting a usable folder and completing the import, an Import complete message appears and a separate paid project file is created.

The paid file looks blank after I imported my trial

  1. Check the filename at the top of Excel. AREKTON_Customer_Starter.xlsm is the blank starter, not your imported project.

  2. Look in the output folder you selected for the automatically generated AREKTON_Paid_Project_[date/time].xlsm file. Open it and check Dashboard project name and Project ID.

  3. If the generated project is also blank, or Import complete never appeared, stop and contact support. Keep the source trial and starter. Report the exact filename, import message and any Step or Error number. Do not enter replacement data to hide an incomplete import.

Expected result: The generated paid project contains the supported trial records and saved packages. Review totals, history and print previews, then save, close and reopen that generated file to check persistence.

My payment application or SOV does not print correctly

  1. Select the intended saved application on Print Setup B5. Open Payment Print or SOV Print and press Ctrl+P. Use the sheet’s saved print area rather than a leftover custom selection.

  2. Check the application number, all line items, amounts, logo and signature areas. Payment Print is intended as one landscape page. SOV Print expands for the saved package and repeats row 10 on continuation pages.

  3. If settings were changed, review page setup against the included guide: landscape for payment/SOV, fit columns to one page wide and leave SOV page height automatic. Do not squeeze a long SOV onto one page vertically. Open the resulting PDF and check every page.

Expected result: The payment summary is readable and the SOV includes every saved line, with headings on continuation pages. If rows are missing or clipped, send the application number, affected sheet and a preview image to support.

The SOV and payment summary show different balances

The SOV work balance is scheduled value less completed work and stored materials. The payment summary’s balance includes retainage still withheld. Compare the labels and retainage before treating the difference as an error.

Trial questions and getting help

Only START HERE and Trial Status are visible

  1. Open the known workbook in supported desktop Excel with macros enabled. Close and reopen after allowing macros if necessary.

  2. If you have not activated the trial, choosing No leaves it NOT STARTED with the two introductory tabs visible. Choose Yes only when ready to start your working project copy.

  3. An already activated trial should retain its original dates. If you expected an existing project but see no activation dates, check that you opened your saved project rather than an untouched starter.

Expected result: The trial is either intentionally NOT STARTED or ACTIVE with populated dates and visible project tabs. Downloading the ZIP does not start the evaluation.

My trial has expired

After 40 calendar days, editing and new billing captures stop. Existing records remain available for viewing, printing and PDF export with macros enabled. Keep the project and its backups. Do not change your computer clock, remove protection or run setup commands to extend the evaluation.

To move to paid, save and close the trial. Open a blank paid starter, enable macros and choose Import Trial Project. Select the saved trial, confirm the summary and choose an existing output folder. Review the separate generated paid project. Keep the original trial backup. There is no automatic charge or paid conversion.

Expected result: The expired trial stays locked while the imported paid project permits intended input edits. Import does not restart the trial.

I still need help

Use arekton.com/support or email darek@arekton.com. Include:

  • Product and workbook version; use Unable to open when you cannot open the workbook. Include its exact filename.

  • Excel version and Windows version.

  • The affected tab and cell or button, and the exact error text.

  • The steps you took and what you expected instead.

  • A screenshot or print-preview image if useful, with confidential information removed.

  • Your order number or purchasing email if the request concerns a paid purchase.

Keep your original project and backup. Do not send passwords, payment-card details or confidential employer/client project files. If a file is needed, arrange an appropriate transfer with support.

Your information is never for sale. AREKTON does not sell or rent your personal information. Requesting help does not subscribe you to marketing. Optional product announcements use the separate signup on arekton.com/feature-requests.