Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Unlinking workbooks

How can I unlink two workbooks?

Alternatively, how can I copy a section of one workbook
containg formulas, into another workbook so that the
formulas transferred to the target workbook do not have
the link to the source workbook?


Lionel
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Unlinking workbooks

Hi,

You can unlink a work book by selecting Edit Links and
chose breake links.

You can just select paste special and select values to
remove links while copying in to another sheet.

Abdul Salam


-----Original Message-----
How can I unlink two workbooks?

Alternatively, how can I copy a section of one workbook
containg formulas, into another workbook so that the
formulas transferred to the target workbook do not have
the link to the source workbook?


Lionel
.

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
Unlinking workbooks Rob graham Excel Discussion (Misc queries) 7 June 17th 08 03:17 PM
unlinking formulas from cells jcontrer Excel Discussion (Misc queries) 2 December 4th 07 08:28 PM
Unlinking Cells LinkChallenged Excel Worksheet Functions 2 March 6th 07 02:04 AM
Copying and 'unlinking' a chart rmellison Excel Discussion (Misc queries) 2 November 8th 05 02:32 PM
Unlinking between workbooks svarnell64 Excel Discussion (Misc queries) 1 August 25th 05 06:39 PM


All times are GMT +1. The time now is 03:58 PM.

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

About Us

"It's about Microsoft Excel"