Welcome Guest
Log In | Register )
You last visited January 17, 2017, 2:51 am
All times shown are
Eastern Time (GMT-5:00)

Excel help

Topic closed. 5 replies. Last post 4 years ago by omiller315.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: January 11, 2013, 11:29 am - IP Logged

Can anyone tell me how I can transfer data from one work book to another where it keeps all its functions still working regardless if the old workbook still exsists after transfering data?

We are all Lucky... just some of us don't realize it!

    SergeM's avatar - slow icon.png
    Economy class
    Belgium
    Member #123700
    February 27, 2012
    4035 Posts
    Offline
    Posted: January 11, 2013, 12:34 pm - IP Logged

    The simplest is "=..." or just make a copy.

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: January 11, 2013, 1:18 pm - IP Logged

      The simplest is "=..." or just make a copy.

      When i copy it i need the old workbook to use the formula's i copied... if i delete the old workbook  the copied version does not work.

      not sure where "=..." would be placed to copy whole worksheet

      We are all Lucky... just some of us don't realize it!

        Avatar

        United States
        Member #41846
        June 23, 2006
        460 Posts
        Offline
        Posted: January 11, 2013, 1:36 pm - IP Logged

        When i copy it i need the old workbook to use the formula's i copied... if i delete the old workbook  the copied version does not work.

        not sure where "=..." would be placed to copy whole worksheet

        you have some references to the workbook. look for and delete or change these references.

          SergeM's avatar - slow icon.png
          Economy class
          Belgium
          Member #123700
          February 27, 2012
          4035 Posts
          Offline
          Posted: January 11, 2013, 3:32 pm - IP Logged

          Find and replace the not working functions, save as Excel 2010 workbook with a new name. If you have addons, switch them all off first. Check your settings.

          Send your file to someone to get it checked.

            Avatar
            Pennsylvania
            United States
            Member #109275
            April 9, 2011
            1503 Posts
            Offline
            Posted: January 11, 2013, 5:49 pm - IP Logged

            Right click on your sheet name at the bottom. Select Move/Copy. Select New Book from the dropdown for "To Book". Should keep all formatting. Should be the same as copying though, so like others suggested you might have an invalid link somewhere.