save just data, no forlumas
 

So with the help of this forum, i have proceeded to make many forumlas
and macros to make my life easier. I am now running into the problem
that there are so many formulas that it is becoming slow and the file
size is increasing. After adding my last formulas
changed
=IF(ISNA(VLOOKUP(A4,Main!$A$2:$C$2000,3,FALSE)),"" ,VLOOKUP(A4,Main!$A$2:$C$2000,3,FALSE))

to
=IF(ISNA(INDEX(Sheet3!$E$2:$E$5000,MATCH(1,($A2=Sh eet3!$D$2:$D$5000)*(F$1=Sheet3!$B$2:$B$5000),0))), "",INDEX(Sheet3!$E$2:$E$5000,MATCH(1,($A2=Sheet3!$ D$2:$D$5000)*(F$1=Sheet3!$B$2:$B$5000),0)))

I realized that my file size nearly doubled. because i put this forumla
in hundreds of cells.

I was wondering if there was a way to save an excel workbook as values
only and not formulas, i know you can save it as text, and cvs, and
other types, but i was hoping i could still save it as an XLS but with
no formula's only values.


Any ideas


--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php...o&userid=31420
View this thread: http://www.excelforum.com/showthread...hreadid=517519