save just data, no forlumas

T

trav

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=Sheet3!$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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top