Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 06:05 PM
tommcbrny
 
Posts: n/a
Default Reference Data in Moved Worksheet

I created a workbook in Excel 2003 that contains 4 worksheets. Cells in one
of the worksheets is populated by linking to cells in the other 3 worksheets.

I want one of the linked worksheets to serve as a standalone form. I move
this worksheet from the existing workbook to a new workbook and save it as a
template. The idea is to have this worksheet completed, add it to the
original workbook, and have the cell links between this worksheet and the
other worksheet maintained.

When I move the worksheet, the links change from 'worksheet name!'$a$1 to
#ref!$a$1, which I expect. When I move the completed worksheet back in to
the workbook, however, the original cell links do not return even though the
worksheet name is the same as when I moved it from the workbook.

Is there a way to maintain these cell links when a worksheet is removed and
readded as I am attempting?

Thanks,

Tom

  #2   Report Post  
Old December 1st 04, 06:49 PM
tommcbrny
 
Posts: n/a
Default

I answered my own question on this one. I can open the workbook that the
original sheet was removed from, change the link source to the new worksheet
that has been completed, and then move this worksheet in to the workbook.
All reference links are updated to capture data from the completed worksheet.


"tommcbrny" wrote:

I created a workbook in Excel 2003 that contains 4 worksheets. Cells in one
of the worksheets is populated by linking to cells in the other 3 worksheets.

I want one of the linked worksheets to serve as a standalone form. I move
this worksheet from the existing workbook to a new workbook and save it as a
template. The idea is to have this worksheet completed, add it to the
original workbook, and have the cell links between this worksheet and the
other worksheet maintained.

When I move the worksheet, the links change from 'worksheet name!'$a$1 to
#ref!$a$1, which I expect. When I move the completed worksheet back in to
the workbook, however, the original cell links do not return even though the
worksheet name is the same as when I moved it from the workbook.

Is there a way to maintain these cell links when a worksheet is removed and
readded as I am attempting?

Thanks,

Tom



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
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Macro does not run when data refreshed Larry Lehman Excel Discussion (Misc queries) 0 January 16th 05 07:31 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Copy data into a NEW worksheet Krefty Excel Discussion (Misc queries) 1 December 22nd 04 01:53 PM
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 1 December 2nd 04 08:30 PM


All times are GMT +1. The time now is 03:22 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017