I'm trying to convert a spreadsheet so that I can import it into a SQL server. It has alot of extra columns that were only used to make calculations on the sheet. Is there anyway I can finalize a sheet, deleteing all the formulas and leaving only the values that were calculated for that cell.

The problem is as I start deleting columns I start getting #REF's popping up cause data is missing. Any help or suggestions are apreciated, Thanks.