Tim Grollman
Board Regular
- Joined
- Feb 24, 2002
- Messages
- 129
I've got a large file with several sheets of 40,000 lines and half a dozen columns. To try and reduce the size of the file I have cleared all unoccupied cells and saved as much as possible as values. I can't store the data as a pivot table.
Another thing which seems to be helping is replacing where possible whole words with codes, so instead of Afghanistan, Albania etc I am saying 1, 2 etc, and pulling back the real name later on. This is apparently having some effect, but not as much as I was hoping. Does one character in a cell occupy 1 Byte of memory? And if so, does a column of 20k single characters occupy 20k of memory? And if so, does the number 123 occupy 3 Bytes? and if so, could I reduce it to a single Byte by coding it as capital H, say?
Thanks to anyone who can advise me on this or on other ways of reducing file size. I have had a quick look at the search results for this, so apologies if I'm suggesting something already well known.
Tim
Another thing which seems to be helping is replacing where possible whole words with codes, so instead of Afghanistan, Albania etc I am saying 1, 2 etc, and pulling back the real name later on. This is apparently having some effect, but not as much as I was hoping. Does one character in a cell occupy 1 Byte of memory? And if so, does a column of 20k single characters occupy 20k of memory? And if so, does the number 123 occupy 3 Bytes? and if so, could I reduce it to a single Byte by coding it as capital H, say?
Thanks to anyone who can advise me on this or on other ways of reducing file size. I have had a quick look at the search results for this, so apologies if I'm suggesting something already well known.
Tim