Cannot make copy of Worksheet in the same work book

  • 3 Replies
  • 95 Views
*

Offline smestarz

  • Bronze Member
  • 141
Cannot make copy of Worksheet in the same work book
« on: February 27, 2019, 09:46:13 AM »
I have MS Office 2016 and recently i found that one of the sheet, I cannot make a copy of it in the same workbook. it freezes the excel 2016
Any help here?

I use Windows 10 Pro X64

*

Offline smestarz

  • Bronze Member
  • 141
Re: Cannot make copy of Worksheet in the same work book
« Reply #1 on: February 27, 2019, 09:52:24 AM »
I noticed that only one spreadsheet i cannot copy in the workbook, rest of the sheets i can make copies of, any suggestions?

*

Offline Hoov

  • Malware Removal Mentors
  • Administrator
  • Diamond Member
  • 27183
  • Unwilling part owner of Gov't. Motors and Chrysler
    • Hoov's Personal Site
Re: Cannot make copy of Worksheet in the same work book
« Reply #2 on: February 27, 2019, 10:15:28 AM »
I have found that when this happens to me, it is something on the worksheet causing problems. Many time it is a hidden character. There is something you can try. Copy half of the data and paste it into a new worksheet. See if you can make a copy of that. If you can, do the same to the other half. Once you find the half that has the problem, you can do half of that. Also you can try copying just the data to a new worksheet, and see if you can copy that. If that is the case, then just delete the old one and use the new one. You can also try un-hiding the non printing characters and see if there is something you did not put in there.

Former Consumer Security MVP
2011-2014

If I am helping you and you don't hear from me for 24Hrs, send me a PM Please!

*

Offline smestarz

  • Bronze Member
  • 141
Re: Cannot make copy of Worksheet in the same work book
« Reply #3 on: February 27, 2019, 11:50:58 AM »
Dear Hoov.

Thank you for your message and  I took the suggestion and did it, and it now works, I was able to identify the problem and clear it,
Thank you

It was getting on my nerves as i could not understand why one particular sheet does not want to be copied