Excel 2003 - Create Copy of Worksheet not working
chris.c...@gmail.com
I am trying to copy a worksheet into a new workbook by right clicking
on the worksheet tab, selecting 'Move or Copy...', then setting 'To
book:' to (new book) and checking off 'Create a copy'. After Clicking
ok, the task bar looks like it flashes a new workbook for less than
have a second and nothing happens. (no error message is displayed)
More information on this particular problem:
- I'm working in Excel 2003
- This workbook is not protected or shared
- This workbook has macros, but I've tried this operation with the
macros enabled and disabled
- This workbook is located on a network drive. When copying the
workbook to another folder on the same drive, the copying of a
worksheet still does not work. When copying the workbook to another
network drive (or local drive), the copy works.
I've searched through this group and have come across people having
the same issue all the way back to 2000, but there doesn't seem to
have been any resolution to the issue. Other posts include:
http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/e07b13ad2edc6b4c/f7d9616c9879f09e?lnk=gst&q=copy+worksheet+not+working#f7d9616c9879f09e
http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/f558e3c532193b35/b457f7296f08d3fa?lnk=gst&q=copy+worksheet+not+working#b457f7296f08d3fa
http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/98dff7a549b761b/c854f99bb0a08390?lnk=gst&q=%22create+copy%22+worksheet#c854f99bb0a08390
If you have any ideas to why this is happening, please let me know. I
appreciate any feedback.
Thanks,
- Chris