![]() |
Copying Worksheets
Hi. I have a user who has a Excel Spreadsheet with numerous Worksheets
within. It will not allow him to copy worksheets from this spreadsheet to a new spreadsheet but it will allow him to move them. The file was originally created in Excel 97 but he now uses Excel 2003. I can copy worksheets using Excel 97 but don't want to downgrade the user. The spreadsheet is not protected in any way and there are no hidden sheets. Any help appreciated. |
Copying Worksheets
Just hazarding a guess here. Can you right-click on a tab and then click on
Move or Copy, then choose Move selected sheets Create a copy. Get all sheets in a new workbook, and just use that new book. Does that work for you? Regards, Ryan-- -- RyGuy "Neil169" wrote: Hi. I have a user who has a Excel Spreadsheet with numerous Worksheets within. It will not allow him to copy worksheets from this spreadsheet to a new spreadsheet but it will allow him to move them. The file was originally created in Excel 97 but he now uses Excel 2003. I can copy worksheets using Excel 97 but don't want to downgrade the user. The spreadsheet is not protected in any way and there are no hidden sheets. Any help appreciated. |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com