FAQ: Concatenate Range

Here are some common issues that people have when using Concatenate Range:

PROBLEM:   How do I add Concatenate Range to my Excel?
SOLUTION: To install Concatenate Range, you can follow the steps on our Instructions page.

PROBLEM:   How do I use Concatenate Range?
SOLUTION: To use Concatenate Range, you can follow the steps on our Instructions page.

PROBLEM:   When I try to install Concatenate Range, I get this error: “Setup cannot continue because some system files are out of date on your system. Click OK if you would like setup to update these files for you now. You will need to restart Windows before you can run setup again. Click cancel to exit setup without updating system files.”
SOLUTION: Run Windows Update to ensure you have .NET Framework 1.1 or higher.

PROBLEM:   I don’t see the CONCATENATERANGE formula!
SOLUTION: It is normal to not see the CONCATENATERANGE formula, because it is a custom formula. However, if you type the formula, it will work perfectly fine.

PROBLEM:        The CONCATENATERANGE formula gives me #NAME?
SOLUTION #1: Concatenate Range is not (fully) installed – follow the steps in our Instructions page to install Concatenate Range.
SOLUTION #2: Excel has not loaded The Concatenate Range add-in – to fix, open Excel, select the File menu (or Office button), click Options, Add-ins, then select COM Add-ins from the dropdown, then click Go.., ensure twCONCATENATERANGE is checked, then click OK. Then select Excel Add-ins from the dropdown (if available), then click Go.., If CONCATENATERANGE is in the list, ensure it is checked, then click OK. Restart Excel.

PROBLEM:   The CONCATENATERANGE formula gives me #VALUE!
SOLUTION: You are trying to pass a bad argument to the CONCATENATERANGE formula – to fix, follow the instructions on how to use Concatenate Range.

PROBLEM:        I get an invalid/expired license message, but I am still in the free trial period (or have purchased Concatenate Range)!
SOLUTION #1: Your Windows user security is too restrictive on your PC – Concatenate Range was tested using default Windows security. Contact us for more information.
SOLUTION #2: Your Windows user is not the user who installed the trial version. The trial version only works for the user who installed the trial version.

PROBLEM:   Nothing happens when I try to use the CONCATENATERANGE formula!
SOLUTION: Your security may be too restrictive – to fix, go to the Instructions page and follow the steps to configure security.

PROBLEM:   I am having other issues. I can’t get this to work!
SOLUTION: Feel free to e-mail Tumbling Wave Support. If you received an Error Code (e.g. Error Code: V9.9-E9999-L99), please include the Error Code in the e-mail.