Copying Worksheets

N

Neil169

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.
 
R

ryguy7272

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--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Need Help with Macro Security 1
Please help me choose a product for the task 2
External cell reference between two excel worksheets both in One Drive 0
hidden rows, column copy-paste 0
Copying Portions of Data 0
Can't insert a new worksheet 8
Enable Iterative Calculations 0

Top