Print Station is actually opening excel file
I have looked without success. How do I prevent a label from opening the referenced excel file?
Yes, it may lock the file while it reads it but I do not want it to open the file on the workstation printing the labels. This creates a situation where ANYONE can accidentally edit data we do not want changed.
That is how it works when a label is linked to an Excel document.
The ODBC driver, that sits between the Excel document and BarTender, opens the spreadsheet so that BarTender can access the data to use. It does not allow any other access and will not write anything to the file by default. You can add a VB routine, for example, that would write something to the file, but it wont do this unless you instruct it to.
If someone has the file open elsewhere, even on the same PC, BarTender will not be able to access the information.0