How do I delete an empty worksheet.

[Guest]

The command to "Delete Sheet" in the "Edit" menu is greyed out

 

[Dave R.]

Is anything else in the edit menu grayed out?

 

[Bob Phillips]

Is it a shared workbook? Take a look at 'Limitations of shared workbooks' in
Excel help.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Jimmy,

Also check to see if the workbook has been protected. You can look up
protection in Excel's on-line help for a good explanation.

 

[Guest]

No it is the only item greyed out. I have checked for the worksheet being
protected which it isnt and finally renamed the file, coopy at vast expense
of my time all the relevant details and then saved my new file under the
original name.

On reflection, this only seems to come about in files which were in use
before I got 2003. One of the Access files repeatedly tells me to check and
make sure the file is safe before loading/using

 

[Guest]

Tried that Bob but thanks anyway

Is it a shared workbook? Take a look at 'Limitations of shared workbooks' in
Excel help.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks John
I did try that but it may be that this is an echo from the previous version
of Office (2000?) but it doesn't really help

 

[Bill Sharpe]

You don't say how many sheets there are in your workbook. One workaround
may be to copy all the sheets you want to keep to another workbook, then
erase the offending workbook. Or is this a global problem, affecting all
your workbooks?

Another approach is to just ignore the empty worksheet. Most of my
workbooks only have entries on Sheet 1, but I never bother to delete the
empty default sheets 2 and 3.

When someone gives you a lemon, make lemonade.

Bill

The command to "Delete Sheet" in the "Edit" menu is greyed out

 

[Bill Sharpe]

If you don't use Excel functions you miss out on about 95% (insert your
own estimate here) of the program's power.

For a more varied response look at what the other posters have to say.

Bill

The command to "Delete Sheet" in the "Edit" menu is greyed out

 

[JulieD]

hi Jimmy

you said you checked for the "worksheet" being protected - but did you check
for the WORKBOOK being protected - tools / protection / protect workbook

Cheers
JulieD

 

[Guest]

Yes Bill,

There were only three sheets and I have just copied them to another new
workbook
which solved the problem but not the use of my time. Ha Ha. The offending
extra worksheet - sheet 4 - was an insult to my limited intelligence and I
looked for a way to remove it. Thanbks anyway

I have read elsewhere that files created using Excel 2000 might not be as
responsive under 2003 version