A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Copying a worksheet - won't work help please

Thread Tools Display Modes
Old March 30th 17, 09:20 PM posted to microsoft.public.excel.misc
external usenet poster
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
Old April 18th 17, 06:38 PM
Dave H Dave H is offline
First recorded activity by ExcelBanter: Apr 2006
Posts: 54

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.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 07:03 PM
Copying the active worksheet to another worksheet in the same work queenmaam Excel Worksheet Functions 5 March 25th 08 06:56 PM
Copying spreadsheets-did not work tazsdad Excel Discussion (Misc queries) 1 December 5th 05 11:48 PM
copying and paste data from each worksheet to a summary work sheet mary Excel Programming 5 January 21st 05 05:25 PM

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

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