Importing an old workbook into a new workbook

  • Thread starter Thread starter Jean Larson
  • Start date Start date
J

Jean Larson

Hi,

I think my Excel Workbook may be corrupted and I was wondering how we
can copy, insert, or import an entire workbook that contains at least a
dozen work sheets in the original file.

Do I have to copy and paste each worksheet one at a time or can I just
import them all?

Jean
 
Open both workbooks.
In the old one, right click a tab and select "Select All Sheets"
Right click a tab again and select "Move or Copy"
In the To book: drop down, select the new worksheet name.
Hit OK and they should all be moved. If you want to just copy them
check the create a copy button.
 
You must log in or register to reply here.

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

Merge Multiple workbook sheets into one workbook 0
Sharing workbooks limitations - Merged Cells 12
import multiple excel books to one excel workbook 3
Import Multiple CSV Files from Same Folder into Open Workbook 5
I get an error message while copying worksheets between workbooks 1
Cannot unprotect workbook with an Excel crash 0
Deleting all named ranges that have a workbook scope 3
Excel 2007 crashes on copying worksheet to new workbook 0

Back
Top