Results 1 to 2 of 2

Thread: What is the formula to copy or move a spreadsheet

  1. #1
    Join Date
    Jan 2012
    Posts
    55

    What is the formula to copy or move a spreadsheet

    I am attempting to copy a sheet that has several named ranges. Each time I have to select whether to keep the names as defined or rename them. Is there a setting that will override this and keep the ranges each time I copy the sheet. Thanks

  2. #2
    Join Date
    May 2011
    Posts
    523

    Re: What is the formula to copy or move a spreadsheet

    1. AFAIK, this type of 'conflicts' arises -only- when you are copying:
    a) formula between worksheets [same workbook] with identical names
    b) worksheets into other workbooks that has identical names

    2) For named-ranges they have two scopes:
    a) global [workbook-level] as the first time you define/create/... the name
    b) local [worksheet-level] when you copy worksheets within the same workbook [or fully-qualifying with the sheet-name while defining the name]

    3) When you copy entire worksheets within the same workbook excel [usually] can *handle* this issue creating a *new* set of local names referring to the *new* sheet if you are performing actions as per 1-a) and/or 1-b) [i guess] you could use macros setting to false Application. DisplayAlerts turning it back to true after completing your copy-actions.

Similar Threads

  1. Convert copy formula to Text in Microsoft Excel
    By Kaesav in forum MS Office Support
    Replies: 2
    Last Post: 01-02-2012, 07:39 PM
  2. How to insert row and copy formula from a Protected Worksheet
    By Calverta in forum MS Office Support
    Replies: 5
    Last Post: 27-01-2012, 07:22 PM
  3. How to Copy formula using Vlookup on Excel?
    By Chellappan in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 08:20 PM
  4. cannot copy data from one spreadsheet to another
    By fANIBHUSAN in forum Windows Software
    Replies: 4
    Last Post: 31-03-2011, 08:15 PM
  5. Replies: 5
    Last Post: 26-02-2009, 07:44 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
  •  
Page generated in 1,711,649,887.04247 seconds with 18 queries