Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 8th 05, 06:27 PM
Rich Ulichny
 
Posts: n/a
Default Copy tabs(sheets) from workbook without link to original source

I want to be able to copy tabs from workbook to workbook. However, when I
right-click..'choose Move or Copy' and copy the tab into a new workbook,
the formula now contains the original source file name.

For example, a simple calc, contained on Sheet2 of my source (book1.xls):

=+Sheet1!A1+Sheet1!A2

becomes

=+[book1.xls]Sheet1!A1+[book.xls]Sheet1!A2

when it's pasted into a new workbook.

I do not want to original link contained in the new workbook. How can I copy
the worksheet without having that orignal source file name in the formula?

Thanks,

Rich




  #2   Report Post  
Old August 9th 05, 09:03 AM
Bill Manville
 
Posts: n/a
Default

If you want the formula to refer to the new workbook's Sheet1 then use
Edit / Links / Change Source after copying the sheet in.

If you want to move Sheet1 and Sheet2 together to the new book, select
both sheets (Ctrl+Click the sheet tab of the second one) before using
Edit / Move or Copy sheet.

If you just want the values of the formula in the new workbook and not
the formula then, having copied the sheet use Select the cells
concerned, Edit / Copy; Edit / Paste Special / Values

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3   Report Post  
Old August 9th 05, 03:26 PM
Rich Ulichny
 
Posts: n/a
Default

Thanks for the suggestions. Option 1 below was exactly what I needed. It
allowed me to change the source to the new workbook that I copied the sheet
into. I didn't realize you could change the source to itself and that would
remove the references to the original workbook.


"Bill Manville" wrote in message
...
If you want the formula to refer to the new workbook's Sheet1 then use
Edit / Links / Change Source after copying the sheet in.

If you want to move Sheet1 and Sheet2 together to the new book, select
both sheets (Ctrl+Click the sheet tab of the second one) before using
Edit / Move or Copy sheet.

If you just want the values of the formula in the new workbook and not
the formula then, having copied the sheet use Select the cells
concerned, Edit / Copy; Edit / Paste Special / Values

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I cannot paste from one workbook to another. Copy works, paste do. JimmyMc Excel Discussion (Misc queries) 1 June 10th 05 03:54 PM
How can I Copy cell names from one workbook to another? G.H.B.B. Excel Discussion (Misc queries) 1 March 24th 05 02:30 AM
Link to password protected workbook dunnotar02 Excel Discussion (Misc queries) 1 March 22nd 05 06:44 PM
copy a sheet in same workbook temporary block excel mircea Excel Worksheet Functions 0 January 22nd 05 12:23 PM
What's the simplest way to copy data from another workbook JohnT Excel Worksheet Functions 0 January 16th 05 01:19 AM


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017