Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 30th 17, 09:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2017
Posts: 1
Default Copying a worksheet - won't work help please

On Sunday, March 5, 2000 at 11:00:00 AM UTC+3, Ber Visser wrote:
The easiest way to copy a worksheet is to select its tab and, whilst
pressing Ctrl and the left mouse button, dragging it to another position.
You will notice that next to the mousepointer a plus sign appears.
Ber Visser
Belgium
=================.
"Don Beck" schreef in bericht
...
Each time I try to copy a worksheet excel basically does nothing. No
new copy is created and I get no error message. I tried to unprotect
the sheet but it isn't protected in the first place. Any suggestions?

Thanks.


You have saved me quite a heap of turmoil. Thankyou

  #2   Report Post  
Old April 18th 17, 06:38 PM
Member
 
First recorded activity by ExcelBanter: Apr 2006
Posts: 54
Default

If you have too many cell formats you can no longer copy a sheet. It will not give you an error message just won't let you copy the sheet. The issue is not from too many formats but from corrupt styles. There are fixes for the too many cell formats on the web. The easy way to see if this is the problem is on your home tab of your ribbon in the style section there is a drop down. When you select the drop down you see many styles that have very funky names then you have this problem. This typically occurs when you copy from other workbooks into your workbook.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying a worksheet - won't work help please [email protected] Excel Discussion (Misc queries) 1 October 16th 15 12:07 AM
Copying one work sheet to another Withnails Excel Programming 3 October 26th 09 08:03 PM
Copying the active worksheet to another worksheet in the same work queenmaam Excel Worksheet Functions 5 March 25th 08 07:56 PM
Copying spreadsheets-did not work tazsdad Excel Discussion (Misc queries) 1 December 6th 05 12:48 AM
copying and paste data from each worksheet to a summary work sheet mary Excel Programming 5 January 21st 05 06:25 PM


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017