Hancom Sheet 7 Excel Woes

[daniel3000]

Hello,

I have a very important Excel sheet file, which I want to use on the Zaurus and under Excel.
Since I have created it, I have swapped the file a few times between Hancom Sheet and Excel (2003) with no major problems. The file has grown to 390kB, which I considered too large but still acceptable.

Today, when editing the file under Excel and saving it, the file size grew to 9MB (!!), although I have only added some cells, shifted around a bit, deleted a table in the sheet and created a new table.

Anyone knows the reason and how to work around that in future?

BTW: Now I have created a new Excel file and copy'n'pasted the cell contents (only text, numbers and a few formulas!) into a new file. Saving that new file resulted in only 35kB of data.

Thanks
daniel

[Cresho]

when i tried word a while back, i had a problem with size as well.  what i did was copy and paste the whole text into a a new word from another word and went down to 100k from 4mb.  wierd stuff but you can try.  control-a control-c and new document..control-v

[GadgetGuy]

Hello,

I have a very important Excel sheet file, which I want to use on the Zaurus and under Excel.
Since I have created it, I have swapped the file a few times between Hancom Sheet and Excel (2003) with no major problems. The file has grown to 390kB, which I considered too large but still acceptable.

Today, when editing the file under Excel and saving it, the file size grew to 9MB (!!), although I have only added some cells, shifted around a bit, deleted a table in the sheet and created a new table.

Anyone knows the reason and how to work around that in future?

BTW: Now I have created a new Excel file and copy'n'pasted the cell contents (only text, numbers and a few formulas!) into a new file. Saving that new file resulted in only 35kB of data.

Thanks
daniel
[div align=\"right\"][a href=\"index.php?act=findpost&pid=97523\"][{POST_SNAPBACK}][/a][/div]

You will find with most MS Office applications, that they can grow without any reason. Very little in the file, still huge file size.

On the PC the quick and easy solution is to Zip it. I once zipped a 10MB file into 50Kb. Alternatively, as already suggested: just copy paste the data into a blank document. That should bring the size back down for a while...

[craigtyson]

He He  One real anoyance with MS Office is the fact that it saves a stub of the printer driver with the file.  Its ment to speed up (re)printing but infact blows the file up to a massive size.  Id try setting up a generic/text printed driver on your MS box and do a print to it then save the file. OR install open office and save the file from there.

[Shawn]

When excel is opening a file from another version of excel(or its equivalent), it is having a hard time determing the last true row of data

I've opened up excel files from older versions and saved them again-they grow incredibly large because now I have 400 rows of real info, and 65000 rows of 'blanks'

Open the file in excel, manually delete all the empty rows below your data and save. It will then save it small again.

S

[daniel3000]

I have tried such things already: I tried to "save as" the file - same size.
I have tried to copy the real info into clipboard and into a new sheet file - same size!
So the huge amount of data must be somewhere in a cell (or several cells) with real data.
But what the heck can take up so much room inside one cell?
I have about (roughly estimated) 200 cells filled, spread over three tables in the sheet file. Only numbers, text and formulas. No macros, scripts, VB or other fancy things.

daniel