Reduse filesize

[Claus]

I trying to make my filesize smaller

I have cells like this:
=HVIS(ER.FEJL(LOPSLAG($C8;Priser;2;FALSK));"";LOPSLAG($C8;Priser;2;FALSK))
in english somthing like this
=if(is.error(llookup($C8;Priser;2;false));"";llookup($C8;Priser;2;false))
Filesize = 591 kB

I tried to reduse filesize by typing this:
=LOPSLAG($C7;Priser;2;FALSK)
English =llookup($C8;Priser;2;false)
Filesize = 592 kB

Why does it take up more and not less space ?

I've tried to change 20 cells and filesize is 593 kB

I have up to aprox. 2500 cells on one sheet where I could reduse like above.


Hoping for an answer.


Claus Persson

 

[Jordon]

Your file is a half a meg and you want to make it smaller?

 

[Claus]

Hi Jordon

I only have a few sheets right now, but i'm gonna have a lot. My first test
shows a final filesize at aprox. 4-5 MB.

Claus