Copy Worksheet Problem

[Donald Roberts]

I am unable to copy certain worksheets in a workbook. All information
(formulas and data) are the same on all. Example: Jan thru May are the
titles of the worksheets. I am unable to make a copy of the worksheet named
May. Jan thru April are ok. Any suggestions?

Donnie Roberts

 

[Frank Kabel]

Hi Donnie
what exactly happens:
- do you receive an error and if yes what error message
- is the data corrupted?

 

[Donald Roberts]

Thanks for your input Frank,

No error messages appear and the data is not corrupted. Excel 2000
I am trying to make an identical copy of the prior month worksheet May to
rename June and then edit. The workbook only contains six worksheets with
relatively small amounts of data. The worksheet is not protected.

I have tired copying the entire worksheet three ways, (1) Control key and
(2) right click then Copy (3) and then from the menu bar, copy sheet. All
fail with the May worksheet. Nothing happens. But all other months
(worksheets) copy properly. Very strange!

Donnie