CONNX Excel Add-In FAQ
One of my changes to the table failed when trying to commit to the database. Why can't I undo that one change?
The only way to eliminate the failing change is to revert changes and get the data from the database. The CONNX Excel Add-In tracks each change as it is made, it does not save a before-and-after value for each cell. A change is reverted by refreshing the data from the source table.
Why are large numbers rounded before being put into the source table?
Excel has a maximum of 15 digits of precision, after that it rounds to zero. For example, if you enter the number 9223372036854775807 in a cell, when Excel Add-In tracks the change, the number Excel gives to the Add-In is 92233720368547700000.
After I open a connection for editing a table on an Excel sheet, in the File -> Info tab of Excel it shows that the sheet is protected. When I press the unprotect link it asks for a password, why?
When a sheet is used to edit a database table, most of the cells are protected. This is necessary to be able to track changes and prevent data loss. The protection cannot be removed.
I am editing a table and the last row is "cnxrowid" but when I change the values, why are they not saved?
The cnxrowid is a way for CONNX to apply a row identifier to a table that has been imported into a data dictionary. This is a virtual column, it does not physically exist on the source table. By checking Show CNXROWID in the data dictionary, this field will show up with the table, however it cannot be edited and changes to that column are not allowed.
When I try to use Replace in the Excel Edit features it says that it cannot be used when the sheet is locked. Why can't I use the replace function?
The primary goal of the CONNX Data Task pane is to allow editing of data in a database table. To accomplish this, some of the Excel functions that are normally available have been eliminated by locking the sheet. For example filtering, sorting, adding, or moving columns would make it impossible to track changes. The spreadsheet is locked in order to disallow these functions.