+ Reply to Thread
Results 1 to 4 of 4

Removing Named Ranges

  1. #1
    Registered User
    Join Date
    12-12-2008
    Location
    Brownsville
    MS-Off Ver
    office 2003
    Posts
    6

    Removing Named Ranges

    I have a worksheet that was created using all the same info from the past 3 years. Only thing is this worksheet is now showing a size of 2.31MB when past ones sow only 733kb. I see under the properties and content tab that there is a part called "Named Ranges" and is has over 65 Print Titles. How do I remove these Named Ranges which might be causing this wrksheet to either load fast or save .

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Properties and content tab? What version of Excel are you using?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-12-2008
    Location
    Brownsville
    MS-Off Ver
    office 2003
    Posts
    6
    microsoft excel 2002

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Insert > Name > Define, select each one that you want to delete, and click Delete.

    I doubt that that's the source of the bloat, though.

+ 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