Solved I would like to copy a spreadsheet with vlookups

April 12, 2013 at 08:27:01
Specs: Windows 7
and other formulas to a new spreadsheet. How do I copy them and get them to hold the formulas? Right now they are just giving me the numbers I can't get formulas to come accross.

See More: I would like to copy a spreadsheet with vlookups

Report •

April 12, 2013 at 12:06:12
✔ Best Answer
These directions assume you have Office 2007 or 2010. I believe Office 2013 is different and I know for sure Office 2003 is different.

Open destination workbook (both workbooks will need to be open in the same Excel window)

In source workbook, right click on tab you want to copy from and select Move or Copy ...

In the To Book window, select the name of the destination workbook, and Select the tab in the destination workbook to insert Before

Click OK, which moves tab from source workbook to destination workbook

Close source workbook without saving (this keeps the original workbook intact without changes)

On the Data tab, in the Connections Group, click 'Edits Links.'

Click on Change Source, then browse for the destination file (the one that is opened) and click ok.

If you need directions for other versions of office, let me konw.

Report •

April 12, 2013 at 12:23:20
Thank you. That did take care of my problem. I have never had to do this before. It will save me a bunch of time!

Report •

April 12, 2013 at 12:30:02
Be sure to stop back by and select the best answer to "Solve" this thread if it works for you!

Also, let me know if you need any more help!

Report •

Related Solutions

April 12, 2013 at 17:43:52
What not just use the Move or Copy feature available via right-clicking the sheet tab?

You can copy a sheet within the same workbook or, by using the "To Book" drop down, to any other open workbook or even to a new workbook.

Just be sure to click the "Create a copy" box, otherwise you'll just move the sheet.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Ask Question