Loading data from OneDrive in TIBCO Spotfire throws error "System.IO.IOException: The process cannot access the file because it is being used by another process"

Loading data from OneDrive in TIBCO Spotfire throws error "System.IO.IOException: The process cannot access the file because it is being used by another process"

When attempting to load a flat file as a data source which is hosted on OneDrive and synced on your desktop through TIBCO Spotfire Analyst, sometimes you will get error like below:

Spotfire.Dxp.Data.Exceptions.ImportException: The process cannot access the file 'C:\Users\abc\OneDrive - company\time-data.xlsx' because it is being used by another process. ---> System.IO.IOException: The process cannot access the file 'C:\Users\abc\OneDrive - company\time-data.xlsx' because it is being used by another process.

  This happens because the file is already open in Excel so OneDrive locks read access for other programs when the "Use Office 2016 to sync Office files that I open" setting is selected and you are trying to load data in TIBCO Spotfire Analyst client.

This specific use case happens only while using OneDrive synced from Office 365 on Desktop. If OneDrive from Office 365 is opened up on browser and file is opened up in Excel online, you will not receive this error while reloading data in TIBCO Spotfire Analyst

To resolve this issue, you can use either of the following approaches:

1. Make sure no files from OneDrive are open in Microsoft Excel at the same time when you are trying to load data in TIBCO Spotfire Analyst.

2. Deselect "Use Office 2016 to sync Office files that I open" option and keep on making changes in excel and TIBCO Spotfire Analyst simultaneously. But real time syncing will be paused once its unchecked.

3. Make changes in Microsoft Excel online through Office 365 OneDrive in browser instead of using Microsoft Excel on desktop. Changes made in Microsoft Excel online are reloaded simultaneously in TIBCO Spotfire Analyst as well without any issues External: Use Office 2016 to sync Office files that I open

• https://support.office.com/en-us/article/use-office-2016-to-sync-office-files-that-i-open-8a409b0c-ebe1-4bfa-a08e-998389a9d823?ui=en-US&rs=en-US&ad=US