Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating linked cells
I have a workbook with a primary worksheet and a secondary worksheet. My
primary worksheet is where I enter most of my numbers and data. My secondary worksheet was made by copying certain items from the primary worksheet and pasting them as a link into the secondary worksheet. It works well, I update or change data in the primary worksheet and the secondary sheet updates. I have problems however when I insert rows into the primary worksheet. Lets say that I insert a row and the inserted row is row 7. In the secondary worksheet my linked cells are still working but as I click on them and look at the link coordinates I see that it skips from row 6 to row 8. It skips over the row I just inserted in the primary worksheet. Is there a way to get the secondary sheet to update when I insert (or delete) a row from the primary worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating linked cells
Hi there - yes this is a common problem and you have to make sure that the
primary and secondary sheets are mirror images of eachother. The best way around this is to build lots of blank entry rows in the primary sheets which are already linked through to the secondary sheet. You then populate the primary sheet as required. (you can hide them until you need them) Hope this makes sense. "BPH" wrote: I have a workbook with a primary worksheet and a secondary worksheet. My primary worksheet is where I enter most of my numbers and data. My secondary worksheet was made by copying certain items from the primary worksheet and pasting them as a link into the secondary worksheet. It works well, I update or change data in the primary worksheet and the secondary sheet updates. I have problems however when I insert rows into the primary worksheet. Lets say that I insert a row and the inserted row is row 7. In the secondary worksheet my linked cells are still working but as I click on them and look at the link coordinates I see that it skips from row 6 to row 8. It skips over the row I just inserted in the primary worksheet. Is there a way to get the secondary sheet to update when I insert (or delete) a row from the primary worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Inserting rows, updating linked worksheet | Excel Worksheet Functions | |||
cells linked to others in same workbook not updating | Excel Discussion (Misc queries) | |||
How to find linked cells | Excel Discussion (Misc queries) | |||
Locked cells not updating | Excel Worksheet Functions |