+ Reply to Thread
Results 1 to 4 of 4

Extremely High UsedRange - Cannot reduce/reset!

  1. #1
    Registered User
    Join Date
    12-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Extremely High UsedRange - Cannot reduce/reset!

    I'm trying to reduce the usedrange of my spreadsheet so I can actually use the scroll bar. My last used cell is apparently IT1048576.(Only need it to go to O687) And I am unable to remove this. I've done the research, but can't get it to work. Macros, deleting cells, etc. Also, its so massive that, most the time, my computer doesn't have the resources to perform the action of deleting them all. (i have deleted only the last used cell, but it doesn't seem to help.)

    You can find my spreadsheet here:
    http://www.mediafire.com/?ht36ij83n2r2dww

    The spreadsheet is too big to post here apparently. (5.03MB)
    I am sorry if providing a link to an offsite file is not allowed. The file is secure, I assure you.

    I would greatly appreciate it.

    Thank you for your time.

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Extremely High UsedRange - Cannot reduce/reset!

    Any chance you can just copy the range you want to keep and move/paste it into a new workbook?

  3. #3
    Registered User
    Join Date
    12-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Extremely High UsedRange - Cannot reduce/reset!

    Why didn't I think of that...

    Thank you very much.

  4. #4
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Extremely High UsedRange - Cannot reduce/reset!

    Glad to help, and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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