LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default Link to range of cells, so formulas are retained

Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.

Is it possible to do this across multiple cells (a range) in one go?
 
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
link a range of cells ken's dilemma Excel Worksheet Functions 4 September 13th 07 07:59 PM
Formatting not retained using paste all and paste link ABCMS Excel Worksheet Functions 1 March 9th 06 12:37 PM
How to link cells in diff't workbooks that don't contain formulas Gustin512 Excel Discussion (Misc queries) 2 September 21st 05 11:26 AM
Formatting cells is not retained when saved as csv file sheba0907 Excel Worksheet Functions 0 September 7th 05 05:39 PM
Formulas link cells Mike Excel Worksheet Functions 0 March 3rd 05 08:11 PM


All times are GMT +1. The time now is 07:14 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"