When I add a row to my source sheet, it doesn't update my linked .

W

WorkingGirl4774

I have a main source sheet that I have linked to other sheets (the same info,
only broken down by city). When I add a row to the main page, it doesn't
update the linked pages. It updates the cells that were already there, but
won't insert new rows when I do on the source sheet. I'd appreciate any
help. Thanks!
 
S

Shane Devenshire

Hi,

Excel never put formula in cell just because. If you want to do this you
can consider 1. Putting formulas in place which are "ready" for new data, 2.
Write VBA code to respond to a change event in the source sheet.

For example if your current linked formulas read

=Sheet1!A1
you could change it to read

=IF(Sheet1!A1="","",Sheet1!A1)

You can copy this type of formula anywhere in the target sheet and it will
be ready for new rows of data and it won't show anything until those source
cells are populated.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

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

Protected Sheet doesn't update linked information 3
Adding a row in a linked worksheet 2
Linked Spreadsheets - Preventing Access to Source Sheet 1
Stop linked cells from changing when insert new row? 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Insert row automatically when row intersted on another sheet in same wkbk 0
How do I link cells, sheet to sheet, to recognize row deletions? 30
How can I get linked data to update inserted rows 2

Top