Linked Cells Staying With Cells Once Linked Workbook Update.

P

paul.morriss

Can any one help.

I have a list on sheet 1 of a workbook that has linked cells to cells
in sheet 2, i.e. Sheet2!A5. Sheet 2 is then linked to Sheet1 of another
'master' workbook.

If the 'master' workbook has a new row added and the other workbook is
updated the new row is added, fine. Problem I have is that now the
linked cells formulas in sheet 1 do not account for the new row,
therefore all values are now wrong.

If I manually insert a new row into sheet 2, the linked cells formulas
in sheet 1 do account for the new row.

Is there any way around this problem, or is it just a Excel 'funny'.

I hope I've explained myself ok and someone out there can help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link To File That No Longer Exists 1
XL2000 Links Between Workbooks 2
Compare two different workbook sheet to show the difference in text 0
Excel 2007 - Linking workbooks 1
Macro to Combine Data from Multiple Sheets with Cell References 4
trouble with (complicated) vlookup searching another workbook 2
Automatically populating cells down a row 8
Automatic refresh in linked worksheet if row is added 1

Top