Stop ODBC refresh from overwriting manual data

[unigee]

Hi,

I have an ODBC that pulls some information from a SQL Server using DSN.
Occasionally we need to manually overwrite the results of the ODBC due to some inaccuracies in the data from the SQL Server.

What has started to happen is when the ODBC is refreshed, all the data that was manually overwritten previously are in turn overwritten with the incorrect data from the ODBC.
I would like to stop this from happening.

I should point out that the column it is happening on is a column that was added after the ODBC was created and a formula is used instead (because when you add a formula to a new column from an ODBC, it automatically populates all the rows)

The odd thing is though, this behavior didn't happen on last years file, and this new file is just a copy of last years file with some adjustments.

Any ideas?
Thanks

 

[CharlesChuckieCharles]

"with some adjustments"

did someone designate the odbc area as a TABLE ?

 

[unigee]

"with some adjustments"

did someone designate the odbc area as a TABLE ?

Not that I could see. By "with some adjustments" I mean someone went in and adjusted the SQL queries for the new financial year (basically changing a number 14 to 15)

I believe it is something to do with the "preserve sort/filter/layout" option in the ODBC settings as when turning this option off it works as expected. Unfortunately it completely ruins the spreadsheet due to all the columns re-adjusting themselves.

Will be a mammoth of a task to fix if I decide this is the only solution