Hi all -- I would really appreciate some ideas on the following situation. I'll try to be concise!
I have a daily automated workflow that sends data to a LAN-based Excel report and then distributes an e-mail containing that same report while also rendering a formatted Alteryx report for viewing from the users' PC's and cell phones. It's working great except that we recently discovered that some users want to view the Excel attachment on their IOS/Android devices but are finding that the results are not updating to the latest day's results. However, the same attachment viewed on a PC updates just fine.
I thought this was maybe a cache issue on the phones at first, but if users install the MS Office app on their phone and open the attachment there it updates there just fine as well. We recently discovered a temporary, manual solution whereby the IOS/Android view is updated just as long as I first open the Excel file on the LAN each morning, hit save, and then close it again before the attached file is distributed. But of course now our automated process is no longer automated, so no more vacations for me until we can figure something out!
Not sure if I'm on the right path, but my hunch is to add some VB to my workflow that would replicate our manual process (Open/Save/Close the entire file on the LAN prior to the email distribution).
If that's the right approach, has anyone encountered a similar issue and been able to solve it? I don't have much VB experience nor know how to incorporate script into a workflow, so a sample workflow would be really helpful. Thanks in advance!
