We have a SQL fed table, with a large number of added calculated columns. All calculated columns function as either vlookups, or sums.
The sum column basically works out a percentage using a couple of the vlookup columns and a column from the SQL result.
Generally the data returned is fine as it is, however once in a while data needs to be entered manually in one of the sum columns. As soon as the table is refreshed any manually entered data is replaced by the formula. Without adding new columns (spreadsheet is already quite a size) is there any way to stop the data being replaced by the formula on refresh.

The refresh needs to happen as it pulls in new figures, and makes sure the SQL results are up to date.

My apologies if this has been answered elsewhere, I have been searching for an answer for quite some time now