Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

MS Excel - File Size

  • 13-06-2006 11:32am
    #1
    bishopLEN
    Closed Accounts Posts: 261 ✭✭


    Hello kind folks,

    When saving an excel file recently my friend saw that the file doubled in size.
    Has anyone come accross this before ?

    Cheers


Comments

  • #2
    petes
    Registered Users, Registered Users 2 Posts: 8,382 ✭✭✭petes


    Is he saving the file in dual format i.e. instead of just a normal worksheet, it is saved in say Excel 95 format aswell as say 2003 format. This would cause the file size to increase. A bit more info would be help as to what version of Excel he is running.


  • #3
    bishopLEN
    Closed Accounts Posts: 261 ✭✭bishopLEN


    It is being saved as a excel 2000 file. As it's original i.e. it should not have any extra version information.

    The file is just over 5meg. Real puzzler.

    Thanks for the reply !


  • #4
    sceptre
    Registered Users, Registered Users 2 Posts: 19,608 ✭✭✭✭sceptre


    Has he got Fast Save turned on?

    (any particular reason why he's using Excel to create Word files?)


  • #5
    bishopLEN
    Closed Accounts Posts: 261 ✭✭bishopLEN


    sceptre wrote:
    Has he got Fast Save turned on?

    (any particular reason why he's using Excel to create Word files?)
    Hi,

    Auto save is turned on alright, this is a major feature that is needed.
    The data in the excel document is important.

    The document also hold many macros and linkages.

    (my bad about that mistake, changed now)


  • #6
    petes
    Registered Users, Registered Users 2 Posts: 8,382 ✭✭✭petes


    Fast save is different than auto save. More information can be found here:

    http://askit.uq.edu.au/itanswers/microsoftoffice/word/filesize.html#fastsave


    Thats actually only for word though. Are there many macros/formulae in the spreadsheet? If so were any macros deleted?


  • Advertisement
  • #7
    bishopLEN
    Closed Accounts Posts: 261 ✭✭bishopLEN


    petes wrote:
    Fast save is different than auto save. More information can be found here:

    http://askit.uq.edu.au/itanswers/microsoftoffice/word/filesize.html#fastsave


    Thats actually only for word though. Are there many macros/formulae in the spreadsheet? If so were any macros deleted?
    There are many macros alright, but none of them have been deleted.


  • #8
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 93,599 Mod ✭✭✭✭Capt'n Midnight


    OT - fast save in word is not your friend, since it reduces the chances of recovering a corrupt document,

    images bloat a lot, (word 95 hitting 20MB per page was common)
    also remove empty worksheets,
    in case there is any junk highlight and delete all cells below the active area and do the same to the right.

    copy all the cells to a new worksheet (leaving the old sheet behind)
    if still big the paste special to rule out what is the big thing

    try file save as - to different versions of excel to see which bloats most


Advertisement