Microsoft Excel – interesting feature Move Copy Worksheet

If you attempt to move or copy an Excel worksheet from a Excel 2007 or later workbook to an Excel 2003 workbook it will fail. The error message displayed does not give you any hint about the incompatibility and suggests cut and paste. You can complete the copy if you make the target workbook the same level as the sending workbook.
Do a Save As of the target worksheet to the new format. Close it. Re-open the just saved version to complete the conversion. The Move or Copy Worksheet function should then work properly.
This presumes that you actually found the Move Copy Worksheet function now conveniently located at Home -> Cells -> Format -> Organize Sheets -> Move Copy Worksheet. Whodda thunk it.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.