Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Copying Worksheets with a List or Table

Today’s author is Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ Problem : It is not possible to copy more than one sheet to a new workbook or existing workbook if there is a List (Excel 2003) or a Table (Excel 2007) in one of the worksheets. How to reproduce: In a new workbook with two or more sheets, add a table or a list in one of the worksheets. Select more than one sheet with the CTRL key held down. (Be Read More...

Read the complete post at http://blogs.msdn.com/excel/archive/2009/09/01/copying-worksheets-with-a-list-or-table.aspx


Posted Aug 31 2009, 11:35 PM by Microsoft Excel
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.