This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 01-05-201704:00 PM - edited on 03-11-201909:35 AM by SydneyF
How do you Input Excel files which may already be open? (i.e. viewed by a user).
The reason we can't read an Excel file when it is open is because Excel puts a write lock on the file. Reading an open file has challenges like... What happens if the file is modified and saved while we are reading it? To avoid those and other edge cases, the decision was made to limit reading and writing Excel files to those that are not currently locked. You can open your file in Excel for "Read Only" and then Alteryx can read the file without any problem.
That said, if you install the Microsoft Access 2010 driver you will be able to use that driver which can read and write to open Excel files. In Alteryx it's called the Excel Legacy driver. However, be aware that if you use the Access driver you may get different results (rounding) depending on whether the file is currently open in Excel or not. The Access driver uses a 2nd library that allows reading and writing to an open file (open with a write lock). The 2nd driver does rounding slightly different from the main driver that is used if the file is not open.
If those limitations are not a problem for you, try the Access driver below: