+ Reply to Thread
Results 1 to 3 of 3

copy formulas from one multitab workbook to other

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    copy formulas from one multitab workbook to other

    I've got a large workbook with many tabs which seems to increase in size over time even after I delete unused cells, columns and rows. Since the original workbook uses about the same number of cells, but is about 1/2 the size, I'm assuming that over time it has accumulated "hidden" information which I no longer use or need.

    I know how to copy entire worksheets from one workbook to another, but often, the formulas will reference the first workbook.

    If I "recreate" a new workbook including fresh tabs with identical names, is there a special paste function which copies formulas without referencing the original .xlxs file?

    Thanks!
    Last edited by jrtaylor; 07-15-2017 at 06:51 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: copy formulas from one multitab workbook to other

    You can use find and replace to change those links quite easily.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    Re: copy formulas from one multitab workbook to other

    Hi thanks. Yes I've used find & replace before but with lots of tabs (and therefore named references) it gets a little tedious. I appreciate your help though!

+ 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: 0
    Last Post: 07-01-2015, 03:33 PM
  2. Bring the cursor back to the first tab if a multitab workbook
    By strmnv3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2015, 04:57 PM
  3. Copy workbook structure & formulas to new blank workbook
    By bweight in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2015, 05:32 PM
  4. Creaate copy of workbook and adjust cell formulas for within the workbook
    By SierraKilo78 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 11:57 PM
  5. How to print userform multitab in landscape.
    By UJAM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2013, 05:19 PM
  6. Scrollbar issue in multitab
    By Stingone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 11:20 AM
  7. How to copy formulas from one workbook to another
    By Confused in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 01:34 PM

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