Copying a worksheet - won't work help please
Don Beck
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.
Gord Dibben
Are you trying to copy the WSheet in the same Workbook? If so,
right-click on the sheet tab and select from the menu "move or copy"
Then make sure you select the Copy check box. Otherwise you will only
move the sheet from where it is to where it is.
When you select copy check box, you should get a new sheet with the
same name + (2). Excel 97 SR2
HTH Gord
Don Beck
times before but suddenly it's not working. Still can't figure it out.
Don
On Sat, 04 Mar 2000 20:01:04 GMT, Gord Dibben <gdi...@home.com>
wrote:
Chrissy R
- save the workbook;
- right click the tab and select 'move/copy'
If the worksheet does not reference any other worksheets in
the workbook
- copy the worksheet to a new workbook (check the copy
check box)
- rename this new worksheet
- move it back (don't check the copy check box)
If the worksheet references other worksheets in the workbook
- move the worksheet to a new workbook (don't check the
copy check box)
- copy it back (check the copy check box)
- rename this new worksheet
- move it back (don't check the copy check box)
If it worked save the updated workbook otherwise do not save
the workbook and open the old copy then:
- save each worksheet in the workbook to a new workbook -
SaveAs Excel 4 will do this.
- recombine the worksheets into one workbook.
All this should give you a copy of the worksheet but it may
avoid whatever is causing the problem.
--
Cheers - Chrissy.
--
"Don Beck" <don...@iname.com> wrote in message
news:38c1e14e...@nntp.ix.netcom.com...
Don Beck
About the only way I've found around this sudden new problem is to
insert a new worksheet and then select all on the worksheet that won't
copy and do an insert copied cells into the new blank worksheet. That
seems to work. Just wish I knew what started all this in the first
place. Thanks for your help.
Don
Ber Visser
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" <don...@iname.com> schreef in bericht
news:38c16434...@nntp.ix.netcom.com...
Chrissy R
corrupt so the best option may be to copy all the formula to
a new workbook then copy all the formatting. This should
eliminate the possible corruption.
--
Cheers - Chrissy.
--
Don Beck worte
lora...@gmail.com
GS
Win10. So many, in fact, that people have suggested M$ did this
deliberately to force people to buy or upgrade newer software. Many
corporations/institutions/government services are issuing bulletins to
*not upgrade to Win10*!
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
joehw...@gmail.com
Dave H
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.
--
Dave H
tchapm...@gmail.com
> 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.