+ Reply to Thread
Results 1 to 4 of 4

Error when trying to copy a worksheet

  1. #1
    Registered User
    Join Date
    02-22-2021
    Location
    Northern Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    6

    Error when trying to copy a worksheet

    I am using Microsoft Office 365 with Windows 10 - all updates done

    Please see uploaded file. This is a sheet from a spreadsheet and i successfully copied worksheets every day in it (for about 7 days) until one day I got an error. I can get past the error and it does copy the worksheet but I can't see how to solve the problem. The earlier sheets on the spreadsheet do copy ok but not the later ones.

    When you copy a worksheet you get a "local_mysql_date_format already exists error" - any help would be appreciated

    The file is password protected spring21

    After I tried Google I checked the Names Manager but there were only print areas there. It let me delete one but not the one remaining. It had no effect on the error.

    Kind regards

    Roy
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Error when trying to copy a worksheet

    You have hidden names in the book. Look at this for a solution: https://support.microsoft.com/en-us/...6-a11a2e148e7b

  3. #3
    Registered User
    Join Date
    02-22-2021
    Location
    Northern Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    6

    Re: Error when trying to copy a worksheet

    Hi GlennUK

    That's superb. Thank you so much.

    I'd never encountered the Document Inspector before nor had I realised there could be hidden names.

    Another skill to learn.

    Much obliged

    Roy

  4. #4
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Re: Error when trying to copy a worksheet

    My pleasure

+ 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. [SOLVED] error 1004 while trying to copy data to another worksheet
    By MaartenRo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2020, 04:55 AM
  2. trying to copy a worksheet to end gives error and I get stuck in a error loop
    By pongmeister in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2017, 11:48 AM
  3. [SOLVED] macro error Copy Time format to other Worksheet and continues copy range
    By feroguz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-25-2012, 01:30 PM
  4. Copy name of worksheet to an error worksheet
    By mineralfellow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2009, 06:42 PM
  5. [SOLVED] Error when trying to copy worksheet within workbook
    By GFC in forum Excel General
    Replies: 2
    Last Post: 05-16-2006, 06:35 PM
  6. Error that prevents Copy Worksheet to another Tab
    By Jeff in forum Excel General
    Replies: 3
    Last Post: 12-04-2005, 07:15 PM
  7. Copy Worksheet Error Message
    By rratcliffe in forum Excel General
    Replies: 0
    Last Post: 06-01-2005, 03:19 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