I have a data connection in my workbook that returns customer data. The connection executes a stored procedure on SQL Server that accepts four parameters. The fourth is a true/false value that I have populated using a checkbox tied to a cell listing the checkbox value. That cell is listed as the fourth parameter in the connection setup, and every parameter is set to trigger an update of the connection on change.
Some of the users of this workbook, however, report the checkbox isn't triggering a change. As far as I can tell, the cell value is updating, but the data connection is not being triggered on everyone's machine. It works on mine and some others.
One other note: The fourth parameter was recently added to this connection, it previously had only three.
Edit: This is using Excel 2007, although I did the development using 2010
Some of the users of this workbook, however, report the checkbox isn't triggering a change. As far as I can tell, the cell value is updating, but the data connection is not being triggered on everyone's machine. It works on mine and some others.
One other note: The fourth parameter was recently added to this connection, it previously had only three.
Edit: This is using Excel 2007, although I did the development using 2010
