+ Reply to Thread
Results 1 to 2 of 2

Reduce file size on 2 sheets in a workbook

  1. #1
    Registered User
    Join Date
    03-24-2022
    Location
    CA
    MS-Off Ver
    365
    Posts
    1

    Post Reduce file size on 2 sheets in a workbook

    Hello. I have a workbook with 11 sheet. The most rows any of these have is about 500 rows. There is one sheet that is just pivot tables. The issue is that this workbook has grown to be over 10BM and is starting to perform very slowly on my old computer. I downloaded the free trial of Professor Excel addon and analyzed the workbook. Of the approx. 10MB, about 9MB is in two sheets. One of these is 495 rows and the other is less than 20. I've tried saving as .xslb as well as change the picot tables to not save the source data with the file. I have attached the entire large workbook. The sheets in question are "#4 BLACK" and "BARWELL"

    Thank you for any all help!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Reduce file size on 2 sheets in a workbook

    In reality, without seeing the workbook, we can only guess.

    However, these situations normally arise when you have formula(e) that go right to the bottom of the sheet, that is, over a million rows. That can happen if, for example, you have formulae that return null values if a particular column is blank. So, maybe, =IF(A2="", "", "some formula"). The output may not be noticeable because there's "nothing" to see.

    You may also have issues with Conditional Formatting being applied to more rows/columns than you think.

    Performance can be affected you have a lot of complex and/or array formulae, especially if they use full column references.

    Typically, you can remedy some of these issue by going to the end of the visible data, selecting all the rows below the data, and deleting using the Delete icon on the ribbon. Similarly for the columns to the right of the visible data. Save, close and re-open the file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 05-18-2023, 07:18 PM
  2. Replies: 6
    Last Post: 08-02-2018, 09:50 AM
  3. How to reduce file size (lots of pictures pasted into workbook)
    By michellepace in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-02-2016, 03:48 AM
  4. Replies: 1
    Last Post: 12-17-2013, 03:18 PM
  5. Reduce workbook size
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2007, 10:48 AM
  6. Re: Need to Reduce the file size
    By Terry Davies in forum Excel General
    Replies: 0
    Last Post: 04-04-2006, 09:20 AM
  7. Reduce size file
    By tempêtje in forum Excel General
    Replies: 2
    Last Post: 03-29-2005, 08:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1