Data Can't Be Sent to Word or Excel Document

Problem: The target document (Microsoft Office) does not receive the sent data.

Solution: Please make sure, that all available Windows and Office updates are installed!

Related Links:

All Scanned Data is Inserted into the Same Cell

Problem: When using Microsoft Excel 2013, the selection does not move automatically to the next cell after inserting. All captured data is inserted into the same cell.

Solution: This feature is available for the following applications:

  • Microsoft Excel 2016 (or newer)
  • Microsoft Excel Online
  • Google Sheets
Workaround: You can also try to use a VBA Macro 🠢 see sample spreadsheet.

When using Microsoft Office 2016, please make sure, that all available Windows and Office updates are installed!
Related Links:

Image Support is Not Available

Problem: Scanned images are not transferred to Office documents.
You receive the following error message: Oops, unfortunately image support is not available in this Office application. Check out the FAQ for details.

Solution: Image support is available for the following applications:

  • Microsoft Word/Excel for Windows (2016 or later)
  • Microsoft Word/Excel for Mac (15.20 or later)
  • Microsoft Word Online
  • Google Sheets

Scan-IT to Office - History

Will Data Be Lost Without an Internet / Add-In Connection?

Don't worry, if the connection to the internet / add-in is lost during data collection or sending to the target application. This data won't get lost!

  • If offline, captured data is stored in the History as unsent (see picture).
  • The app transmits this data automatically when the internet connection is restored.
  • The data is then forwarded in the same order as it was entered.
  • Users can also manually resend individual data records from the history or resend the complete history, if required.

Please refer to the Scan-IT to Office User Manual for further information.

How to Connect Multiple Add-Ins?

If you want to forward captured data to multiple target documents (e.g. in case of multiple locations, offices, etc.), you have to connect the Scan-IT to Office app with further add-ins:

  • Open the main menu (Open contextual menu ) of your Scan-IT to Office App.
  • Select Add Connection from the menu
  • Select Scan QR-Code and scan the QR code of the add-in you want to pair
    (In the add-in you can show the QR-code with the button Add Phone ( Add Phone )below your Configured Phones list)
  • Repeat these steps with as many add-ins as you like :)
All currently connected add-ins and their connection states, are listed in the app item Show Connections in the main menu (Open contextual menu)

Can't Send Barcode Data... (on Mac OS)

Problem: You receive the following error message in the Scan-IT to Office App if you send data to Office on Mac OS: Can’t send barcode data to a Microsoft Office document. Please connect this app with Microsoft Office. This error message is displayed if the connection between App and Add-In is lost for some reason.

Solution 1: Deactivate computer sleep mode in the system settings under Energy Saver on Mac OS.
Solution 2: Re-pair the Scan-IT to Office App with the Scan-IT to Office Add-In. Contact support@tec-it.com in case of recurring problems.

Office Add-In on Android: Unsupported Server Location

Disable DOM Storage Error Message

Problem: If you download the Scan-IT Office Add-In on your Android device, the file can't be opened and/or installed, because this add-in is only supported on desktop devices. You receive the following error message: Can’t open file. Sorry, Scan-IT-to-Office---Barcodescanner-for-Office.xlsx is stored in an unsupported server location.

Solution 1: Insert the add-in directly into your Office application:

  • Go to the menu bar and click Insert
  • Now choose My Add-Ins
  • Open the store and search for Scan-IT to Office
  • Click on Add

Solution 2: Download the Add-In from Microsoft AppSource on your Desktop PC or Mac.

Enable JavaScript for Scan-IT to Office

Office Add-In Does Not Work Because of Disabled JavaScript

Problem: JavaScript is required to use the Scan-IT to Office add-in. If JavaScript is disabled, you receive the following error message: JavaScript is required to use this add-in. Please check the FAQ to correct this.

Solution: Enable JavaScript by setting Active Scripting to Enable under Security - Custom - Custom level in your Internet Options.

Image FAQ

Office Add-In Does Not Show Any Features

Problem: The Scan-IT to Office Add-In looks inactive and only displays the buttons "Phones", "Log" and "Options" without functionality.

Solution: Add the Scan-to-Office Add-In as a trusted site as follows:

  • Start Internet Explorer.
  • Click on the icon Icon Settings and then on Internet Options.
  • Open the tab Security and then select the Trusted Sites zone.
  • Click on the button Sites.
  • A dialog to add new trusted sites will appear.
  • Enter https://tecit-sto-office.azurewebsites.net in the text field and click the button Add.
  • Close Internet Explorer and restart your Office application. The add-in should now be displayed correctly.
Another possible reason for this problem might be a disabled JavaScript setting. See next FAQ entry.

Office Add-In Does Not Work Because of an App Error

Problem: When you use Microsoft Office 2013 or later, you may receive the following error message:
APP ERROR: This app could not be started. Close this dialog to ignore the problem or click "Restart" to try again.

Solution: For Office 2013, first make sure that the update in the following Microsoft Knowledge Base article is installed: Update KB2986156 for Office 2013 (May 12, 2015)

Re-enable protected mode for Restricted Sites in Internet Explorer:

  • Open the Internet Explorer and click the tools button Icon Settings, and then click Internet Options.
  • Click the Security tab, and then select the Restricted Sites Zone.
  • Select the Enable Protected Mode check box, and then click OK.
  • Restart Internet Explorer.
For further information on this topic, please check out the Microsoft Support.
DOM Storage is Not Available in Your Browser

Settings Will Not be Saved

Problem: The Scan-IT to Office add-in shows the following error message: DOM storage is not available in your browser. The add-in is operable but settings will not be saved permanently. Please check the FAQ to correct this.

Solution: Make sure that Enable DOM Storage is checked in the Internet Options under Advanced - Security.

Use Scan-IT to Office with Lookup and Reference Function in Excel

Task: You want to capture an item with Scan-IT to Office in Microsoft Excel (e.g. for inventory) and that the article name appears automatically from a separate item list.

Solution: With VLOOKUP, Microsoft Excel provides a lookup and reference function, which lets you assign captured data in a table automatically. For example, you will find an item based on the deposited item number.

VLOOKUP is composed as follows:

VLOOKUP Function in Excel
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) 

Example:

  • =VLOOKUP(A5;ItemList!$A:$B;2)

Useful Links:

How to Upload Custom Input Forms on iOS Devices?

You can copy files between your computer and apps on your iOS device using File Sharing with Apple iTunes. The next few steps show how it works:

  1. Open iTunes on your Mac or PC
  2. Connect your iPhone or iPad to your computer
  3. Click your device in iTunes

  4. Input form Upload
  5. In the left sidebar, click File Sharing
  6. Select the Scan-IT to Office App
  7. Drag and drop files from a folder in the documents list or click Add. Please note that the file name has to start with "form_"
  8. iTunes copies these files to the app on your device
  9. Restart the Scan-IT to Office App on your device
  10. The uploaded Custom Input Forms are now displayed in your app

  11. Input form Upload
For further information about file sharing with iTunes, please check out the Apple Support.

Google Sheets Add-On Can't Insert Data Because of Authorization Error

Problem: If a different account is logged in to Google Chrome than in Google Sheets, the add-on may not have write permissions for spreadsheets.

  • The following error message appears when opening the add-on:
    Error: Multiple accounts issues. Please log out of your account john.doe1@gmail.com to use Scan-IT to Office with the account john.doe2@gmail.com.
  • The following error message appears when scanning data :
    Error on Insert: ScriptError: Authorization is required to perform that action.

Workaround: To solve this problem, please try these two possibilities:

  • Log out or change the account that is logged in to the Chrome Browser.
  • Share the spreadsheet with the account logged into the Chrome Browser.

Google Sheets Add-On Stops Receiving Data After a Period of Time

Problem: Connection between the app and the Google Sheets add-on is lost or interrupted after a period of time. Restarting the add-on helps but it makes using the app inconvenient.

Solution: This issue might be caused by a functionality of Google Chrome that closes unused/inactive connections. To change the setting, please, proceed as follows:

  1. Open a Google Sheets document
  2. Open the URL chrome://discards/ in a new browser tab
  3. Now search the line with the opened Google document and click on the Toggle button in the Auto Discardable column to disable this option (see the screenshot):

  4. Google Sheets Auto Discardable Settings