+ Reply to Thread
Results 1 to 5 of 5

Move or copy a worksheet not working

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Move or copy a worksheet not working

    I wanted to move my worksheets to a new workbook so I clicked on the first sheet tab down the bottom of the page held CTRL and selected the rest of the worksheets, then went to 'Format' tab at top of page and selected"Move or copy a worksheet". From drop down menu selected 'Move' destination "New workbook"
    The new workbook opened up and was blank. Some how I seem to have lost all of my work. The original workbook was saved as .xlsx and I use excel 2007.
    Any help to retrieve the worksheets would be appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Move or copy a worksheet not working

    Right click the worksheet tab & click Move Or Copy & follow the prompts.

  3. #3
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Move or copy a worksheet not working

    Thank you kindly for your reply and yes, that is a good idea. Unfortunately at the moment the right click on my mouse button is not working properly So instead I accessed the same menu through the toolbar at the top of the page and followed the prompts, just like you said. but after i done that instead of a new workbook coming up with all of my work there, a new work book came up and it was blank. Just like I mentioned in my original post.
    So, thanks anyway, done that, it did not work, that is why I was asking for help.

  4. #4
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Move or copy a worksheet not working

    Go & buy a new mouse

  5. #5
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Move or copy a worksheet not working

    yeah.... I get that, I know I need a new mouse. I've already ordered one. In the mean time I thought I found a way around " right click on the tab and follow the prompts " Are you telling me that using the tool bar to access the same menu was the wrong thing to do. What I am asking is there any way to retrieve my work or does anyone know why It disappeared in the first place.

+ 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. How to move or copy worksheet from one xls to another.
    By gaby58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2017, 05:48 PM
  2. Move or Copy worksheet to new workbook
    By savetrees in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2014, 03:16 AM
  3. Macro Copy to another worksheet move to next row
    By nguyeda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2009, 04:18 AM
  4. Edit / Move or copy sheet stopped working in Excel 2003
    By kris2u in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-04-2005, 04:05 PM
  5. Copy worksheet instead of Move
    By Darren Hill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2005, 09:06 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