Weird Issue During Excel Export
Posted on 2014-01-10
I'm encountering a weird error that we seem unable to resolve. I have an MS Access application that exports data into an Excel worksheet and formats the worksheet to look like a Gantt chart. This process has worked great for years across multiple OS's, processor types, etc.
I recently deployed this application at a new client and it is not working properly. The back-end is in Azure, SQL Server 2012. The front-end is in MS Access 2013 and works great in my environment no matter how many variations of VM's I create to test it, and it also works great for the client's IT machines.
However, the report/export does not work properly on the machines of the end users. Basically, it stops formatting altogether around column "IK" (245). After that, it no longer can set column widths, merge cells, add borders, etc.
Any thoughts on what might be going on?