Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Making it smaller

    I have an workbook that contains over 370 pages that I distribute to 75 users. You can imagine the size of the file. Just saving the file takes a while! For the most part - only the screen portion of a page is used. Example: I just use the range A1:Z50. If I could elimnate the unused parts of the sheets it would surely reduce the size of the file??
    - Ricky

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Making it smaller

    Am I correct? Can I eliminate the vast unused area of ther sheets and reduce the file size in the process? If so, how?
    - Ricky

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Making it smaller

    It is difficult to advise on this one without more details of the sheet.

    Do you mean you have 370 worksheets, and are the "unused" parts of the sheets empty, or just not viewed ?. Do you use 370 ranges from A1:Z50 ?

    You cannot remove unused rows or columns. You could ensure that the empty cells have minimal impact on file size by making sure they are clear of all unnecessary value and formatting.

    Regards,

    Andrew C

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Making it smaller

    Yes, I have 370 worksheets within the workbook. Actually more... There is a seperate worksheet for every day of the year where the user will enter 15 - 20 numbers (sales, taxes, voids, etc.) The other worksheets simply compile this information into useable weekly and monthly reports.
    The viewable area of the worksheet is all I use to make it easier for the end-user. The unviewed portion of the worksheet is not used at all, no formulas, nothing. I was hoping there would be a way to eliminate this huge amount of unused real estate and reduce the entire file size in the process.
    - Ricky

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Making it smaller

    Hi Ricky,

    Would it be possible, rather that using one worksheet per day, to use just one for the year, with a row allocated for each day - that's just 365 rows. It could be structured a database and populated with the help of a Data Form.

    It is just an idea but worth exploring, if agreeable to you.

    regards,
    Andrew

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Pune
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making it smaller

    Even better is to structure the data as a Pivot List and generate a Pivot Table to each user. File Size will be immensely smaller, giving much more utility.

Posting Permissions

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