Good evening,
I have a spreadsheet (lets call that the Main File) that has 5 connections that pull data from another file (lets call that the Data File). When I click "Refresh All", the data is pulled from the Data File into the Main File and all is well. When someone has the Data File opened on a different computer and the data is refreshed, the data is pulled as normal, however it opens the Data File in "Read Only" mode. Normally it does not open the file at all. This cannot happen as that Data File is not supposed to be seen by the user. Does anyone know a way to stop this from happening? It only happens when the Data File is opened, but it may be opened when the Main File is being used.
Connection string/Command Text for one of the 5 connections is below:
DSN=Excel Files;DBQ=F:\OPS\BOARD SHEETS\SP Data File.xlsx;DefaultDir=F:\OPS\BOARD SHEETS;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;
SELECT `EMTs$`.EMTs
FROM `F:\OPS\BOARD SHEETS\SP Data File.xlsx`.`EMTs$` `EMTs$`
Thanks for the help!!
I have a spreadsheet (lets call that the Main File) that has 5 connections that pull data from another file (lets call that the Data File). When I click "Refresh All", the data is pulled from the Data File into the Main File and all is well. When someone has the Data File opened on a different computer and the data is refreshed, the data is pulled as normal, however it opens the Data File in "Read Only" mode. Normally it does not open the file at all. This cannot happen as that Data File is not supposed to be seen by the user. Does anyone know a way to stop this from happening? It only happens when the Data File is opened, but it may be opened when the Main File is being used.
Connection string/Command Text for one of the 5 connections is below:
DSN=Excel Files;DBQ=F:\OPS\BOARD SHEETS\SP Data File.xlsx;DefaultDir=F:\OPS\BOARD SHEETS;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;
SELECT `EMTs$`.EMTs
FROM `F:\OPS\BOARD SHEETS\SP Data File.xlsx`.`EMTs$` `EMTs$`
Thanks for the help!!
