Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Excel - highlight new data (by date ?) and avoid 'Save As' | Excel Discussion (Misc queries) | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
save original data after macro is run again | New Users to Excel | |||
Sort pages? | Excel Discussion (Misc queries) |