Error: "This action cannot be completed because the other program is busy" is showing up when trying to export replenishment to Excel from SPOS

PROBLEM

Error: "This action cannot be completed because the other program is busy" window is coming up when trying to export the replenishment on Excel on SPOS.

The windows will freeze and a message box in the left top corner comes with a message 'Switch to'.

ENVIRONMENT

Shireburn Point of Sale

SOLUTION

As a solution, go through the following:

1. Close SPOS from the Task Manager.
   
2. Open Excel and go to:
   
1. File >Options > Trust Centre >Trust Centre Settings
   
2. File blocking settings and untick all those boxes in the Open column (as shown below)
   
3. Open SPOS and try exporting again

CAUSE

File blocking settings on Excel will block the export. These need to be turned off. More info found here https://docs.microsoft.com/en-us/office/troubleshoot/settings/file-blocked-in-office

• Related Articles

• Error: "Primary key column was not found in the excel sheet" when trying to re-import items from Excel

  ERROR Error: "Primary key column was not found in the excel sheet" when trying to re-import items from Excel when you are trying to re-import items that you have amended from Excel. ENVIRONMENT SIMS SOLUTION Follow the procedure below: Re-export the ...

• How to import and export data through Excel

  You can export data to Excel by going to Support > Stock cards and right-clicking the blue box button in the top-left corner of the data grid (near the column headers). Then navigate to Export to Microsoft Excel and select the required fields (note ...

• Importing details into the system using Excel

  To import details into the system from Excel, you must first generate a template with the column names. This can be done by right-clicking the small blue box at the top-left corner of the grid you wish to populate and pressing the Generate Microsoft ...

• Error: "Missing DSK.dll from..." when opening SFS application

  Problem The error "Missing DSK.dll from......" pops up when trying to launch SFS for the first time after installation of the application on a new machine or when a new user profile has been created on a machine that already has SFS installed. ...

• Error: "File is in use. [,Tranpost.dbf] 227 openssltable" when creating an invoice

  Problem Error: "File is in use. [,Tranpost.dbf] 227 openssltable" when creating an invoice.   Environment SIMS All supported environments Solution Delete the tranpost folder located in the TEMP folder. Full path below: C:\Program Files ...