Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: [xls 97] Why this file is so huge

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,

    I don't understand why a file with 12 columns, 450 rows without Formulas, Conditional Formatting, just with borders and Font format (size, bold) has a size of 1,600 KB.
    When I save this file as txt file is just 30 KB.

    Is it corrupted?
    Is it normal?
    Or do I forget something to clean?


  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you save the file as another version ?
    Check to see in the saveas dialog.
    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When I used to write programs years ago for the Commodore Amiga, saving on memory was very important. I found that if the computer was having to work hard while testing the programs, they would always be huge files when I saved them. To solve this I would simply cut the code and copy it into a new document, saving it before making any more changes. This would dramatically reduce the size of the file.

    I really don't know if computers have this problem today. As files sizes are no longer such a big deal Iíve never tried, but it's worth a go I suppose.

    Greg

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •