In December 2017, we launched ParallelDots Excel add-in which is now helping various non-developers to use our text analysis APIs without writing a single line code and the ParallelDots Excel add-in has now been downloaded more than 10,000 times. After various iterations, we have successfully completed the Beta Phase of ParallelDots Excel add-in. Also, we have resolved all the bugs reported by our users. You can download the latest version here.
In this article, we have discussed a few troubleshooting steps for issues which you might face while using ParallelDots Excel add-in.
Paste-as-values after analyzing in Excel add-in:
After analyzing the rows or columns, once you close the excel after saving your sheet and re-opening the sheet later, you might face the issue of increase in quota. This will be due to the running of formula again on the ParallelDots formula column.
To avoid this, please follow the steps mentioned below:
Step 1 – Select the row or column in which you have applied the formula and select a different row in which you want to paste the analyzed data.
Step 2 – Go to the Home →Select Paste → Select Paste Special.
Step 3 -A pop-up box will appear, select Values under Paste and click on OK.
Step 4 – Delete the row or column in which the formula was applied.
This will not let the quota increase and will keep your data safe and secure.
Please check the GIF below to see a detailed description:
Activate manual mode:
Excel has a range of options allowing you to control the way it calculates. You should always keep the formula mode as manual after analyzing the data as it will not let the quota increase for your ParallelDots account. Please follow these steps to enable manual mode:
Step 1 – After analyzing any data, Click on Formulas in the taskbar.
Step 2 – Select Calculation options in the Formulas.
Step 3 – In the drop down, out of the 3 option displayed, select the manual option.
This will protect your excel spreadsheet from running the formula automatically even after closing your spreadsheet and opening it again.
Whenever you are analyzing the data and your free hits are exhausted before completing the analysis, you can always upgrade your account by purchasing a subscription. If your ParallelDots Excel add-in is open at the time of upgrading your account then your quota will not be updated. Once you have upgraded then just sign out and sign in again in the ParallelDots Excel add-in, to get your updated quota.
Further, you can check the video here to learn how to use ParallelDots Excel add-in.
Also, check here the documentation of ParallelDots Excel add-in.
Click here to check Google Sheets add-on troubleshooting steps.
We hope that these steps will help you troubleshoot the problems you face with the ParallelDots Excel Add-in. Please mail to firstname.lastname@example.org if you are facing other issues while using ParallelDots Excel add-in.