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.


--
kincaid05
------------------------------------------------------------------------
kincaid05's Profile: http://www.excelforum.com/member.php...o&userid=25232
View this thread: http://www.excelforum.com/showthread...hreadid=387197