+ Reply to Thread
Results 1 to 6 of 6

Which Is Better ? Save Entire WB & Delete Unwanted Sheets Or ???

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Which Is Better ? Save Entire WB & Delete Unwanted Sheets Or ???

    .
    I've recently read where it was considered better to SAVE AN ENTIRE WB and delete the unneeded sheets ... rather than ... copying one or more
    sheets to another workbook.

    Both workbooks are almost identical with the exception of a few sheets.


    Which is better or safer ?


    For what it is worth, I've been copying a sheet from WB 1 and pasting to WB 2, where it replaces an existing sheet of the same name. The existing sheet
    is deleted and the pasted sheet is renamed to the orginal sheet. And I've been experiencing issues of corruption after awhile.


    Thanks !

  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: Which Is Better ? Save Entire WB & Delete Unwanted Sheets Or ???

    Where sheets have links between them, I’d expect complications copying and deleting sheets. For what it's worth, I’d go for copying the workbook and deleting unnecessary worksheets.

    Think you've probably answered your own question.
    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


  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Which Is Better ? Save Entire WB & Delete Unwanted Sheets Or ???

    .
    How do I get rid of these "ghost" worksheets ?


    Corrupted.jpg

  4. #4
    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: Which Is Better ? Save Entire WB & Delete Unwanted Sheets Or ???

    I don't know. The icon makes it look as though they are workbook references. Don't think I’ve ever seen that before.

    I'd try selecting all the valid worksheets and copying them as a group to a new workbook.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Which Is Better ? Save Entire WB & Delete Unwanted Sheets Or ???

    .
    Thanks TMS .

    I did just that ... moved them to another workbook.

  6. #6
    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: Which Is Better ? Save Entire WB & Delete Unwanted Sheets Or ???

    You're welcome. Thanks for the rep.

+ 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. VBA macro code hel to save a copy all sheets or entire file in a folder
    By sctr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-18-2017, 07:44 AM
  2. Default Compare 2 sheets and delete entire row if don't match
    By lapot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2016, 02:27 PM
  3. how to delete unwanted cells & delete the rest
    By annux08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2015, 05:34 AM
  4. Delete One Row + Copy All Sheets + Save As
    By AllThingsIan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2014, 11:49 AM
  5. delete entire rows based on cell value in multiple sheets
    By forquaidian in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2014, 05:31 AM
  6. unable to delete entire row of empty cells in columns across multiple sheets.
    By CCLaMor in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2014, 02:03 PM
  7. Macro to loop through all sheets and delete unwanted columns
    By LemonTwist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2009, 12:03 PM

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