Hi,
I am currently using Excel 2003, I have a 3.11mb file with about 20
worksheets, this file has been around much longer than I have. Every month I
would copy 4 worksheets to another workbook. This month I am no longer able
to do this, I right click the tab, and choose move or copy, and choose the
workbook, and check create a copy, nothing will happen, it does not matter if
I right click on the worksheet tab or use the Edit menu. It will let me move
the worksheet, but it will not allow me to copy it. I got an error message
on named ranges (saying they already exist) when I moved it to a new workbook
and then tried to copy it back to the orginal, I looked at the name ranges,
and there had to be over 50 of them, I don't need them, so I deleted them
all, expect one. it will not allow me to delete it, and it is refering to a
workbook that no longer exist, before the name of the range it has to square
boxes, I can not rename or deleted it, I dont know if this has anything to
do with not being to copy the workbook.
Please help if you can
Thanks